APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_PRTT_ENRT_ACTN_F

Line 2558: ben_prtt_enrt_actn_f pea

2554: and ctu.all_r_any_cd = 'ALL'
2555: and exists (select null
2556: from ben_pl_bnf_f pbn,
2557: ben_prtt_enrt_rslt_f pen,
2558: ben_prtt_enrt_actn_f pea
2559: where pbn.business_group_id = ctu.business_group_id
2560: and pbn.per_in_ler_id = p_per_in_ler_id
2561: and pbn.bnf_person_id = p_rcpent_person_id
2562: and pen.prtt_enrt_rslt_stat_cd is null

Line 2586: ben_prtt_enrt_actn_f pea

2582: from sys.dual
2583: where exists (select null
2584: from ben_pl_bnf_f pbn,
2585: ben_prtt_enrt_rslt_f pen,
2586: ben_prtt_enrt_actn_f pea
2587: where pbn.business_group_id = p_business_group_id
2588: and pbn.per_in_ler_id = p_per_in_ler_id
2589: and pbn.bnf_person_id = p_rcpent_person_id
2590: and pen.prtt_enrt_rslt_stat_cd is null

Line 2631: ben_prtt_enrt_actn_f pea

2627: and ctu.all_r_any_cd = 'ALL'
2628: and exists (select null
2629: from ben_elig_cvrd_dpnt pdp,
2630: ben_prtt_enrt_rslt_f pen,
2631: ben_prtt_enrt_actn_f pea
2632: where pdp.business_group_id = ctu.business_group_id
2633: and pdp.per_in_ler_id = p_per_in_ler_id
2634: and pdp.dpnt_person_id = p_rcpent_person_id
2635: and pen.prtt_enrt_rslt_stat_cd is null

Line 2659: ben_prtt_enrt_actn_f pea

2655: from sys.dual
2656: where exists (select null
2657: from ben_elig_cvrd_dpnt_f pdp,
2658: ben_prtt_enrt_rslt_f pen,
2659: ben_prtt_enrt_actn_f pea
2660: where pdp.business_group_id = p_business_group_id
2661: and pdp.per_in_ler_id = p_per_in_ler_id
2662: and pdp.dpnt_person_id = p_rcpent_person_id
2663: and pen.prtt_enrt_rslt_stat_cd is null