DBA Data[Home] [Help]

APPS.BEN_EXT_PREM dependencies on BEN_PRTT_PREM_BY_MO_F

Line 64: from ben_prtt_prem_by_mo_f prm

60: ,prm.cr_val
61: ,prm.yr_num
62: ,prm.mo_num
63: ,prm.last_update_date
64: from ben_prtt_prem_by_mo_f prm
65: , ben_prtt_prem_f ppe
66: where ppe.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
67: and ppe.prtt_prem_id = prm.prtt_prem_id
68: and p_effective_date between prm.effective_start_date and prm.effective_end_date

Line 71: l_tot_val ben_prtt_prem_by_mo_f.val%type ;

67: and ppe.prtt_prem_id = prm.prtt_prem_id
68: and p_effective_date between prm.effective_start_date and prm.effective_end_date
69: and p_effective_date between ppe.effective_start_date and ppe.effective_end_date ;
70: l_include varchar2(1) ;
71: l_tot_val ben_prtt_prem_by_mo_f.val%type ;
72: l_tot_cr_val ben_prtt_prem_by_mo_f.cr_val%type ;
73: --
74: BEGIN
75: --

Line 72: l_tot_cr_val ben_prtt_prem_by_mo_f.cr_val%type ;

68: and p_effective_date between prm.effective_start_date and prm.effective_end_date
69: and p_effective_date between ppe.effective_start_date and ppe.effective_end_date ;
70: l_include varchar2(1) ;
71: l_tot_val ben_prtt_prem_by_mo_f.val%type ;
72: l_tot_cr_val ben_prtt_prem_by_mo_f.cr_val%type ;
73: --
74: BEGIN
75: --
76: --

Line 147: from ben_prtt_prem_by_mo_f prm

143: ,csk.segment2
144: ,csk.segment3
145: ,apr.actl_prem_typ_cd
146: ,prm.prtt_prem_by_mo_id
147: from ben_prtt_prem_by_mo_f prm
148: , ben_prtt_prem_f ppe
149: , ben_actl_prem_f apr
150: , pay_cost_allocation_keyflex csk
151: where ppe.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id