[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select prm.val
,prm.cr_val
,prm.yr_num
,prm.mo_num
,prm.last_update_date
from ben_prtt_prem_by_mo_f prm
, ben_prtt_prem_f ppe
where ppe.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
and ppe.prtt_prem_id = prm.prtt_prem_id
and p_effective_date between prm.effective_start_date and prm.effective_end_date
and p_effective_date between ppe.effective_start_date and ppe.effective_end_date ;
(p_last_update_date => prem.last_update_date,
p_mo_num => prem.mo_num ,
p_yr_num => prem.yr_num ,
p_effective_date => p_effective_date,
p_include => l_include) ;
select apr.actl_prem_id
,prm.val
,prm.uom
,prm.cr_val
,prm.mnl_adj_flag
,prm.cr_mnl_adj_flag
,prm.yr_num
,prm.mo_num
,prm.last_update_date
,csk.concatenated_segments
,csk.cost_allocation_keyflex_id
,csk.segment1
,csk.segment2
,csk.segment3
,apr.actl_prem_typ_cd
,prm.prtt_prem_by_mo_id
from ben_prtt_prem_by_mo_f prm
, ben_prtt_prem_f ppe
, ben_actl_prem_f apr
, pay_cost_allocation_keyflex csk
where ppe.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
and ppe.prtt_prem_id = prm.prtt_prem_id
and ppe.actl_prem_id = apr.actl_prem_id
and prm.cost_allocation_keyflex_id = csk.cost_allocation_keyflex_id(+)
--and prm.yr_num = to_number(to_char(p_effective_date,'YYYY'))
--and prm.mo_num = to_number(to_char(p_effective_date,'MM'))
and p_effective_date between prm.effective_start_date and prm.effective_end_date
and p_effective_date between ppe.effective_start_date and ppe.effective_end_date
and p_effective_date between apr.effective_start_date and apr.effective_end_date ;
(p_last_update_date => prem.last_update_date,
p_mo_num => prem.mo_num ,
p_yr_num => prem.yr_num ,
p_effective_date => p_effective_date,
p_include => l_include) ;
ben_ext_person.g_prem_last_upd_date := prem.last_update_date;