DBA Data[Home] [Help]

APPS.BEN_BATCH_REPORTING dependencies on BEN_PRTT_ENRT_RSLT_F

Line 719: from ben_prtt_enrt_rslt_f pen

715: where bli.benefit_action_id = l_ler_info.benefit_action_id
716: and bli.person_id = l_ler_info.person_id
717: and exists (
718: select null
719: from ben_prtt_enrt_rslt_f pen
720: where pen.per_in_ler_id=bli.per_in_ler_id
721: and rownum=1
722: union
723: select null

Line 912: from ben_prtt_enrt_rslt_f pen

908: where bli.benefit_action_id = l_ler_info.benefit_action_id
909: and bli.person_id = l_ler_info.person_id
910: and exists (
911: select null
912: from ben_prtt_enrt_rslt_f pen
913: where pen.per_in_ler_id=bli.per_in_ler_id
914: and rownum=1
915: union
916: select null