APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 94: from ben_prtt_enrt_rslt_f pen

90: Cursor c_rslt_rec (p_pl_id number ) is
91: select pen.pgm_id,
92: pen.per_in_ler_id,
93: pen.prtt_enrt_rslt_id
94: from ben_prtt_enrt_rslt_f pen
95: where pen.person_id = p_person_id
96: and pen.pl_id = p_pl_id
97: and pen.prtt_enrt_rslt_stat_cd is null
98: and pen.business_group_id = p_business_group_id

Line 414: from ben_prtt_enrt_rslt_f pen,

410: select unique pen.person_id
411: /* pen.prtt_enrt_rslt_id, pen.person_id, pen.pl_id, pen.oipl_id,
412: pen.pgm_id, pen.pl_typ_id
413: */
414: from ben_prtt_enrt_rslt_f pen,
415: per_all_people_f per
416: where per.person_id = pen.person_id
417: and per.business_group_id = pen.business_group_id
418: and p_effective_date between per.effective_start_date