APPS.BEN_PREM_PRTT_CREDITS_MO dependencies on BEN_PRTT_PREM_F

Line 38: from ben_prtt_enrt_rslt_f pen, ben_prtt_prem_f ppe,

34: pen.pl_id, pen.oipl_id, pen.person_id, pen.ler_id, pen.pl_typ_id,
35: pen.prtt_enrt_rslt_stat_cd, pen.sspndd_flag, pil.per_in_ler_stat_cd,
36: pen.effective_start_date, pen.effective_end_date,
37: pen.enrt_cvg_strt_dt
38: from ben_prtt_enrt_rslt_f pen, ben_prtt_prem_f ppe,
39: ben_per_in_ler pil
40: ,ben_prtt_prem_by_mo_f prm, ben_actl_prem_f apr
41: where
42: ( (pen.sspndd_flag = 'N'

Line 168: from ben_actl_prem_f apr, ben_prtt_prem_f ppe

164: apr.cr_lkbk_val, ppe.prtt_prem_id, apr.wsh_rl_dy_mo_num,
165: apr.rndg_cd, apr.rndg_rl, ppe.std_prem_val, apr.prsptv_r_rtsptv_cd,
166: apr.lwr_lmt_calc_rl, apr.lwr_lmt_val,
167: apr.upr_lmt_calc_rl, apr.upr_lmt_val
168: from ben_actl_prem_f apr, ben_prtt_prem_f ppe
169: where apr.prem_asnmt_cd = 'ENRT'
170: and apr.cr_lkbk_val is not null -- bug 1213601
171: and apr.cr_lkbk_val <>0
172: and ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id