APPS.BEN_PREM_PRTT_MONTHLY dependencies on BEN_PRTT_PREM_BY_MO_F

Line 377: from ben_prtt_prem_by_mo_f prm, ben_prtt_prem_f ppe

373:
374: cursor c_premium (p_prtt_enrt_rslt_id number,
375: p_effective_start_date date, p_effective_date date) is
376: select distinct 'Y'
377: from ben_prtt_prem_by_mo_f prm, ben_prtt_prem_f ppe
378: where ppe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
379: and ppe.prtt_prem_id = prm.prtt_prem_id
380: -- any premiums between esd of result and date we are voided it
381: and to_date(to_char(prm.mo_num)||'-'||to_char(prm.yr_num), 'mm-yyyy')

Line 612: from ben_prtt_prem_by_mo_f prm

608: cursor c_prm (p_prtt_prem_id number) is
609: select prm.prtt_prem_by_mo_id, prm.object_version_number,
610: prm.mnl_adj_flag,prm.uom,prm.val,prm.cr_val,prm.cost_allocation_keyflex_id
611: , effective_start_date
612: from ben_prtt_prem_by_mo_f prm
613: where prm.mo_num = p_mo_num
614: and prm.yr_num = p_yr_num
615: and prm.prtt_prem_id = p_prtt_prem_id
616: -- order by make sure all the time cursor hit the first row

Line 625: from ben_prtt_prem_by_mo_f prm

621:
622: cursor c_prm_ovn (p_prtt_prem_id number,p_effective_dt date) is
623: select prm.prtt_prem_by_mo_id, prm.object_version_number,
624: prm.mnl_adj_flag,prm.uom,prm.val,prm.cr_val,prm.cost_allocation_keyflex_id
625: from ben_prtt_prem_by_mo_f prm
626: where prm.mo_num = p_mo_num
627: and prm.yr_num = p_yr_num
628: and prm.prtt_prem_id = p_prtt_prem_id
629: and p_effective_dt between prm.effective_start_date and prm.effective_end_date;

Line 835: p_base_table_name => 'BEN_PRTT_PREM_BY_MO_F',

831: -- Bug 4892354 : Get Valid Update Modes
832: --
833: dt_api.Find_DT_Upd_Modes
834: (p_effective_date => l_prm.effective_start_date,
835: p_base_table_name => 'BEN_PRTT_PREM_BY_MO_F',
836: p_base_key_column => 'PRTT_PREM_BY_MO_ID',
837: p_base_key_value => l_prm.prtt_prem_by_mo_id,
838: p_correction => l_correction_mode,
839: p_update => l_update_mode,

Line 894: p_base_table_name => 'BEN_PRTT_PREM_BY_MO_F',

890: -- Bug 4892354 : Get Valid Update Modes
891: --
892: dt_api.Find_DT_Upd_Modes
893: (p_effective_date => l_prm.effective_start_date,
894: p_base_table_name => 'BEN_PRTT_PREM_BY_MO_F',
895: p_base_key_column => 'PRTT_PREM_BY_MO_ID',
896: p_base_key_value => l_prm.prtt_prem_by_mo_id,
897: p_correction => l_correction_mode,
898: p_update => l_update_mode,