APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 913: ben_prtt_enrt_rslt_f pen,

909: prv.cmcd_rt_val, -- Bug 6015724
910: prv.rt_strt_dt,
911: prv.rt_end_dt
912: from ben_prtt_rt_val prv,
913: ben_prtt_enrt_rslt_f pen,
914: ben_elig_per_elctbl_chc epe
915: where epe.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
916: and epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
917: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 948: ben_prtt_enrt_rslt_f pen

944: prv.cmcd_rt_val, -- Bug 6015724
945: prv.rt_strt_dt,
946: prv.rt_end_dt
947: from ben_prtt_rt_val prv,
948: ben_prtt_enrt_rslt_f pen
949: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
950: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
951: and pen.prtt_enrt_rslt_stat_cd is null
952: and prv.prtt_rt_val_stat_cd is null

Line 985: ben_prtt_enrt_rslt_f pen

981: prv.cmcd_rt_val, -- Bug 6015724
982: prv.rt_strt_dt,
983: prv.rt_end_dt
984: from ben_prtt_rt_val prv,
985: ben_prtt_enrt_rslt_f pen
986: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
987: and pen.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
988: and pen.prtt_enrt_rslt_stat_cd is null
989: and prv.prtt_rt_val_stat_cd is null

Line 1195: from ben_prtt_enrt_rslt_f pen

1191: and prv.prtt_rt_val_stat_cd is null
1192: and prv.business_group_id = p_business_group_id
1193: and prv.prtt_enrt_rslt_id in
1194: (select pen.prtt_enrt_rslt_id
1195: from ben_prtt_enrt_rslt_f pen
1196: where pen.person_id = p_person_id
1197: and pen.prtt_enrt_rslt_stat_cd is null
1198: and pen.business_group_id = p_business_group_id
1199: );