DBA Data[Home] [Help]

APPS.BEN_EXT_ADV_CONDITIONS dependencies on BEN_EXT_RSLT_DTL

Line 836: from ben_ext_rslt_dtl xrd

832: This curosr ischanged for performance
833:
834: cursor c_check_for_dup_rcds is
835: select 'x'
836: from ben_ext_rslt_dtl xrd
837: where xrd.ext_rslt_id = p_ext_rslt_id
838: and xrd.person_id = p_person_id
839: and xrd.ext_rcd_id = p_ext_rcd_id
840: and nvl(xrd.val_01,'X') = nvl(ben_ext_fmt.g_val_tab(1),'X')

Line 1452: from ben_ext_rslt_dtl xrd

1448: xrd.val_297,
1449: xrd.val_298,
1450: xrd.val_299,
1451: xrd.val_300
1452: from ben_ext_rslt_dtl xrd
1453: where xrd.ext_rslt_id = c_rslt_id
1454: and xrd.person_id = c_per_id
1455: and xrd.ext_rcd_id = c_extrcd_id
1456: ;

Line 2245: ben_ext_rslt_dtl

2241:
2242:
2243: cursor c_ext_rslt_dtls is
2244: select * from
2245: ben_ext_rslt_dtl
2246: where ext_rslt_id = p_ext_rslt_id
2247: and (person_id = p_person_id or p_person_id is null ) -- for subgroup
2248: and ext_rcd_id = p_ext_rcd_id
2249: and ext_rcd_in_file_id = p_ext_rcd_in_file_id