APPS.BEN_PREM_PRTT_CREDITS_MO dependencies on BEN_PRTT_PREM_BY_MO_F

Line 40: ,ben_prtt_prem_by_mo_f prm, ben_actl_prem_f apr

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'
43: -- Credits for 'normal' stuff and
44: -- Task 417: Credits for:

Line 125: ( select pmo.prtt_prem_by_mo_id from ben_prtt_prem_by_mo_f pmo

121: ppe.effective_start_date and ppe.effective_end_date
122: and p_effective_date between
123: prm.effective_start_date and prm.effective_end_date
124: and not exists
125: ( select pmo.prtt_prem_by_mo_id from ben_prtt_prem_by_mo_f pmo
126: where pmo.prtt_prem_by_mo_id = prm.prtt_prem_by_mo_id
127: and pmo.cr_val is not null
128: )
129: )

Line 189: from ben_prtt_prem_by_mo_f prm

185: ,p_process_yr_num number
186: ,p_interim varchar2 ) is
187: select prm.val, prm.prtt_prem_by_mo_id, prm.mo_num, prm.yr_num,
188: prm.object_version_number, prm.effective_start_date
189: from ben_prtt_prem_by_mo_f prm
190: where prm.prtt_prem_id = p_prtt_prem_id
191: and prm.mo_num = p_process_mo_num
192: and prm.yr_num = p_process_yr_num
193: and prm.business_group_id+0 = p_business_group_id