[Home] [Help]
379:
380: cursor c_premium (p_prtt_enrt_rslt_id number,
381: p_effective_start_date date, p_effective_date date) is
382: select distinct 'Y'
383: from ben_prtt_prem_by_mo_f prm, ben_prtt_prem_f ppe
384: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
385: and ppe.prtt_prem_id = prm.prtt_prem_id
386: -- any premiums between esd of result and date we are voided it
387: and to_date(to_char(prm.mo_num)||'-'||to_char(prm.yr_num), 'mm-yyyy')
614: cursor c_prm (p_prtt_prem_id number) is
615: select prm.prtt_prem_by_mo_id, prm.object_version_number,
616: prm.mnl_adj_flag,prm.uom,prm.val,prm.cr_val,prm.cost_allocation_keyflex_id
617: , effective_start_date
618: from ben_prtt_prem_by_mo_f prm
619: where prm.mo_num = p_mo_num
620: and prm.yr_num = p_yr_num
621: and prm.prtt_prem_id = p_prtt_prem_id
622: -- order by make sure all the time cursor hit the first row
627:
628: cursor c_prm_ovn (p_prtt_prem_id number,p_effective_dt date) is
629: select prm.prtt_prem_by_mo_id, prm.object_version_number,
630: prm.mnl_adj_flag,prm.uom,prm.val,prm.cr_val,prm.cost_allocation_keyflex_id
631: from ben_prtt_prem_by_mo_f prm
632: where prm.mo_num = p_mo_num
633: and prm.yr_num = p_yr_num
634: and prm.prtt_prem_id = p_prtt_prem_id
635: and p_effective_dt between prm.effective_start_date and prm.effective_end_date;
837: -- Bug 4892354 : Get Valid Update Modes
838: --
839: dt_api.Find_DT_Upd_Modes
840: (p_effective_date => l_prm.effective_start_date,
841: p_base_table_name => 'BEN_PRTT_PREM_BY_MO_F',
842: p_base_key_column => 'PRTT_PREM_BY_MO_ID',
843: p_base_key_value => l_prm.prtt_prem_by_mo_id,
844: p_correction => l_correction_mode,
845: p_update => l_update_mode,
896: -- Bug 4892354 : Get Valid Update Modes
897: --
898: dt_api.Find_DT_Upd_Modes
899: (p_effective_date => l_prm.effective_start_date,
900: p_base_table_name => 'BEN_PRTT_PREM_BY_MO_F',
901: p_base_key_column => 'PRTT_PREM_BY_MO_ID',
902: p_base_key_value => l_prm.prtt_prem_by_mo_id,
903: p_correction => l_correction_mode,
904: p_update => l_update_mode,