APPS.BEN_GENERATE_DPNT_COMM dependencies on BEN_PL_BNF_F

Line 225: ben_pl_bnf_f pbn1

221: and ctu.all_r_any_cd = 'ALL'
222: and exists
223: (select null
224: from ben_prtt_enrt_rslt_f pen1,
225: ben_pl_bnf_f pbn1
226: where pen1.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
227: and pen1.prtt_enrt_rslt_id = pbn1.prtt_enrt_rslt_id
228: and pbn1.bnf_person_id = p_rcpent_person_id
229: and pen1.prtt_enrt_rslt_stat_cd is null

Line 250: ben_pl_bnf_f pbn1

246: and epe.per_in_ler_id = pil.per_in_ler_id
247: and epe.elctbl_flag = 'Y'
248: and exists (select null
249: from ben_prtt_enrt_rslt_f pen1,
250: ben_pl_bnf_f pbn1
251: where pbn1.business_group_id = pil.business_group_id
252: and pbn1.bnf_person_id = p_rcpent_person_id
253: and pbn1.per_in_ler_id = pil.per_in_ler_id
254: and pen1.prtt_enrt_rslt_stat_cd is null

Line 706: ben_pl_bnf_f pbn

702: -- and pep.effective_start_date = p_effective_date
703: and pep.elig_flag = p_eligible_flag
704: and exists (select null
705: from ben_prtt_enrt_rslt_f pen,
706: ben_pl_bnf_f pbn
707: where pen.business_group_id = p_business_group_id
708: and pbn.business_group_id = pen.business_group_id
709: and pbn.bnf_person_id = p_rcpent_person_id
710: and pen.prtt_enrt_rslt_stat_cd is null

Line 737: ben_pl_bnf_f pbn

733: -- and pep.effective_start_date = p_effective_date
734: and pep.elig_flag = p_eligible_flag
735: and exists (select null
736: from ben_prtt_enrt_rslt_f pen,
737: ben_pl_bnf_f pbn
738: where pen.business_group_id = p_business_group_id
739: and pbn.business_group_id = pen.business_group_id
740: and pbn.bnf_person_id = p_rcpent_person_id
741: and pen.prtt_enrt_rslt_stat_cd is null

Line 1139: from ben_pl_bnf_f pbn1,

1135: and ctu.effective_end_date
1136: and ctu.cm_typ_id = p_cm_typ_id
1137: and ctu.all_r_any_cd = 'ALL'
1138: and exists (select null
1139: from ben_pl_bnf_f pbn1,
1140: ben_per_in_ler pil
1141: where pbn1.bnf_person_id = p_rcpent_person_id
1142: and pbn1.business_group_id = pen.business_group_id
1143: and pbn1.effective_start_date = p_effective_date

Line 1163: from ben_pl_bnf_f pbn,

1159: and prv.elctns_made_dt = p_effective_date
1160: and pen.business_group_id = prv.business_group_id
1161: and pen.per_in_ler_id <> prv.per_in_ler_id
1162: and exists (select null
1163: from ben_pl_bnf_f pbn,
1164: ben_per_in_ler pil
1165: where pbn.bnf_person_id = p_rcpent_person_id
1166: and pbn.business_group_id = pen.business_group_id
1167: and pbn.effective_start_date = p_effective_date

Line 1540: from ben_pl_bnf_f pbn1,

1536: and ctu.cm_typ_id = p_cm_typ_id
1537: and ctu.all_r_any_cd = 'ALL'
1538: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1539: and exists (select null
1540: from ben_pl_bnf_f pbn1,
1541: ben_per_in_ler pil
1542: where pbn1.bnf_person_id = p_rcpent_person_id
1543: and pbn1.business_group_id = pen.business_group_id
1544: and pbn1.effective_start_date = p_effective_date

Line 1559: from ben_pl_bnf_f pbn,

1555: and pen.prtt_enrt_rslt_stat_cd is null
1556: and pen.per_in_ler_id = p_per_in_ler_id
1557: and pen.enrt_cvg_thru_dt < hr_api.g_eot
1558: and exists (select null
1559: from ben_pl_bnf_f pbn,
1560: ben_per_in_ler pil
1561: where pbn.bnf_person_id = p_rcpent_person_id
1562: and pbn.business_group_id = pen.business_group_id
1563: and pbn.effective_start_date = p_effective_date

Line 1913: from ben_pl_bnf_f pbn

1909: and ctu.effective_end_date
1910: and ctu.cm_typ_id = p_cm_typ_id
1911: and ctu.all_r_any_cd = 'ALL'
1912: and exists (select null
1913: from ben_pl_bnf_f pbn
1914: where pbn.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1915: and pbn.bnf_person_id = p_rcpent_person_id
1916: and pbn.business_group_id = pel.business_group_id
1917: and p_effective_date

Line 1935: from ben_pl_bnf_f pbn

1931: and p_effective_date
1932: between pen.effective_start_date
1933: and pen.effective_end_date
1934: and exists (select null
1935: from ben_pl_bnf_f pbn
1936: where pbn.per_in_ler_id = pil.per_in_ler_id
1937: and pbn.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1938: and pbn.bnf_person_id = p_rcpent_person_id
1939: and pbn.business_group_id = pil.business_group_id

Line 2292: from ben_pl_bnf_f pbn

2288: and ctu.effective_end_date
2289: and ctu.cm_typ_id = p_cm_typ_id
2290: and ctu.all_r_any_cd = 'ALL'
2291: and exists (select null
2292: from ben_pl_bnf_f pbn
2293: where pbn.bnf_person_id = p_rcpent_person_id
2294: and pbn.business_group_id = pel.business_group_id
2295: and pbn.per_in_ler_id = pel.per_in_ler_id
2296: and pbn.effective_start_date = p_effective_date);

Line 2307: from ben_pl_bnf_f pbn

2303: and pil.business_group_id = p_business_group_id
2304: and epe.business_group_id = pil.business_group_id
2305: and epe.per_in_ler_id = pil.per_in_ler_id
2306: and exists (select null
2307: from ben_pl_bnf_f pbn
2308: where pbn.bnf_person_id = p_rcpent_person_id
2309: and pbn.business_group_id = pil.business_group_id
2310: and pbn.per_in_ler_id = pil.per_in_ler_id
2311: and pbn.effective_start_date = p_effective_date);

Line 2556: from ben_pl_bnf_f pbn,

2552: and ctu.effective_end_date
2553: and ctu.cm_typ_id = p_cm_typ_id
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

Line 2584: from ben_pl_bnf_f pbn,

2580: cursor c_bnf_always is
2581: select null
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

Line 3175: from ben_pl_bnf_f pbn,

3171: and ctu.effective_end_date
3172: and ctu.cm_typ_id = p_cm_typ_id
3173: and ctu.all_r_any_cd = 'ALL'
3174: and exists (select null
3175: from ben_pl_bnf_f pbn,
3176: ben_prtt_enrt_rslt_f pen
3177: where pbn.business_group_id = ctu.business_group_id
3178: and pbn.per_in_ler_id = p_per_in_ler_id
3179: and pbn.bnf_person_id = p_rcpent_person_id

Line 3196: from ben_pl_bnf_f pbn,

3192: cursor c_bnf_always is
3193: select null
3194: from sys.dual
3195: where exists (select null
3196: from ben_pl_bnf_f pbn,
3197: ben_prtt_enrt_rslt_f pen
3198: where pbn.business_group_id = p_business_group_id
3199: and pbn.per_in_ler_id = p_per_in_ler_id
3200: and pbn.bnf_person_id = p_rcpent_person_id

Line 3542: from ben_pl_bnf_f pbn

3538: and ctu.effective_end_date
3539: and ctu.cm_typ_id = p_cm_typ_id
3540: and ctu.all_r_any_cd = 'ALL'
3541: and exists (select null
3542: from ben_pl_bnf_f pbn
3543: where pbn.business_group_id = pel.business_group_id
3544: and pbn.bnf_person_id = p_rcpent_person_id
3545: and pbn.effective_start_date = p_effective_date
3546: and pbn.per_in_ler_id = pel.per_in_ler_id);

Line 3552: from ben_pl_bnf_f pbn

3548: cursor c_bnf_always is
3549: select null
3550: from sys.dual
3551: where exists (select null
3552: from ben_pl_bnf_f pbn
3553: where pbn.business_group_id = p_business_group_id
3554: and pbn.bnf_person_id = p_rcpent_person_id
3555: and pbn.effective_start_date = p_effective_date
3556: and pbn.per_in_ler_id = p_per_in_ler_id);

Line 3859: from ben_pl_bnf_f pbn,

3855: ctu.effective_start_date and ctu.effective_end_date
3856: and ctu.cm_typ_id = p_cm_typ_id
3857: and ctu.all_r_any_cd = 'ALL'
3858: and exists (select null
3859: from ben_pl_bnf_f pbn,
3860: ben_prtt_enrt_rslt_f pen
3861: where pbn.business_group_id = ctu.business_group_id
3862: and pbn.per_in_ler_id = p_per_in_ler_id
3863: and pbn.bnf_person_id = p_rcpent_person_id

Line 3881: from ben_pl_bnf_f pbn,

3877: cursor c_bnf_always is
3878: select null
3879: from sys.dual
3880: where exists (select null
3881: from ben_pl_bnf_f pbn,
3882: ben_prtt_enrt_rslt_f pen
3883: where pbn.business_group_id = p_business_group_id
3884: and pbn.per_in_ler_id = p_per_in_ler_id
3885: and pbn.bnf_person_id = p_rcpent_person_id