APPS.BEN_PRTT_PREM_API dependencies on BEN_ELIG_PER_ELCTBL_CHC

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 119: from ben_elig_per_elctbl_chc

115: -- bof FONM
116:
117: cursor c_epe is
118: select *
119: from ben_elig_per_elctbl_chc
120: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id ;
121: l_epe_row c_epe%rowtype ;
122:
123: l_fonm_date date := nvl(p_enrt_cvg_strt_dt,p_lf_evt_ocrd_dt); -- prem created on cvg date so use first