APPS.BEN_PRTT_PREM_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 71: from ben_prtt_enrt_rslt_f pen, ben_elig_per_elctbl_chc epe, ben_enrt_bnft b

67: select pen.bnft_amt, pen.person_id, pen.pgm_id,
68: pen.pl_id, pen.oipl_id, pen.pl_typ_id, pen.per_in_ler_id, pen.ler_id,
69: epe.elig_per_elctbl_chc_id, b.enrt_bnft_id, pen.business_group_id,
70: b.entr_val_at_enrt_flag, b.cvg_mlt_cd
71: from ben_prtt_enrt_rslt_f pen, ben_elig_per_elctbl_chc epe, ben_enrt_bnft b
72: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
73: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
74: and b.elig_per_elctbl_chc_id(+) = epe.elig_per_elctbl_chc_id
75: and pen.prtt_enrt_rslt_stat_cd is null

Line 663: from ben_prtt_enrt_rslt_f pen

659: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
660: --
661: cursor c_per_in_ler is
662: select pen.per_in_ler_id
663: from ben_prtt_enrt_rslt_f pen
664: where pen.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
665: pen.prtt_enrt_rslt_stat_cd is null and
666: pen.business_group_id+0=p_business_group_id and
667: p_effective_date between

Line 1263: from ben_prtt_enrt_rslt_f pen

1259: l_per_in_ler_id ben_prtt_prem_f.per_in_ler_id%TYPE;
1260: --
1261: cursor c_per_in_ler is
1262: select pen.per_in_ler_id
1263: from ben_prtt_enrt_rslt_f pen
1264: where pen.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
1265: pen.prtt_enrt_rslt_stat_cd is null and
1266: pen.business_group_id+0=p_business_group_id and
1267: p_effective_date between