Castor doesn't return results, yet SQL works in adhoc

Here is what SQL Server sees when this statement executes:

Yes That one did come across in a prepare statement...

declare @p1 int
set @p1=1
exec sp_prepare @p1 output,N'@P0 nvarchar(4000),@P1 int',N'SELECT "T_ATR_PRTY"."OBJ_ID","T_ATR_ADDR"."obj_id","T_ATR_PH_NUM"."OBJ_ID","T_ATR_PRTY"."test","T_ATR_USR_PROF"."OBJ_ID",
"T_ATR_USR_PROF"."BR_OBJ_ID","T_ATR_USR_PROF"."crt_dt","T_ATR_USR_PROF"."EMP_NUM","T_ATR_USR_PROF"."FLD_LGN_NUM",
"T_ATR_USR_PROF"."USR_STUS_LKP_OBJ_ID","T_ATR_USR_PROF"."FRST_NM","T_ATR_USR_PROF"."LST_LGN_DT","T_ATR_USR_PROF"."LST_NM",
"T_ATR_USR_PROF"."MID_INIT","T_ATR_USR_PROF"."USR_NM","T_ATR_USR_PROF"."USR_PROF_OBJ_ID","T_ATR_USR_PROF_ROLE"."OBJ_ID",
"T_ATR_USR_PROF_AUDT_ENTR"."OBJ_ID","ATR_Branch_Manager"."OBJ_ID"
FROM "T_ATR_USR_PROF"
LEFT OUTER JOIN "T_ATR_ADDR" ON "T_ATR_USR_PROF"."OBJ_ID"="T_ATR_ADDR"."PRTY_OBJ_ID"
LEFT OUTER JOIN "T_ATR_PH_NUM" ON "T_ATR_USR_PROF"."OBJ_ID"="T_ATR_PH_NUM"."PRTY_OBJ_ID"
LEFT OUTER JOIN "T_ATR_USR_PROF_ROLE" ON "T_ATR_USR_PROF"."OBJ_ID"="T_ATR_USR_PROF_ROLE"."USR_PROF_OBJ_ID"
LEFT OUTER JOIN "T_ATR_USR_PROF_AUDT_ENTR" ON "T_ATR_USR_PROF"."OBJ_ID"="T_ATR_USR_PROF_AUDT_ENTR"."USR_PROF_OBJ_ID"
LEFT OUTER JOIN "ATR_Branch_Manager" ON "T_ATR_USR_PROF"."OBJ_ID"="ATR_Branch_Manager"."USR_PROF_OBJ_ID","T_ATR_PRTY"
WHERE "T_ATR_USR_PROF"."OBJ_ID"="T_ATR_PRTY"."OBJ_ID"
AND ("T_ATR_USR_PROF"."USR_NM" = @P0
and "T_ATR_USR_PROF"."USR_STUS_LKP_OBJ_ID" = @P1) ',1
select @p1

Followed by...
exec sp_execute 1,N'crouchkl',1

If you could not provide us with a junit test, would it be possible to attach at least DDL script with example data for the tables involved. They should be:

• T_ATR_USR_PROF
• T_ATR_ADDR
• T_ATR_PH_NUM
• T_ATR_USR_PROF_ROLE
• T_ATR_USR_PROF_AUDT_ENTR
• ATR_Branch_Manager

Here's the DDLs. I've included DDLs for tables that are not referenced in the Castor mapping, but are part of SQL Server.