APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on BEN_PRTT_PREM_BY_MO_F

Line 619: from ben_prtt_prem_by_mo_f prm

615: l_pbm c_pbm%rowtype;
616:
617: cursor c_prm (p_prtt_prem_id number, p_mo_num number, p_yr_num number) is
618: select prm.prtt_prem_by_mo_id,prm.val,prm.cr_val,mnl_adj_flag, prm.object_version_number
619: from ben_prtt_prem_by_mo_f prm
620: where prm.mo_num = p_mo_num
621: and prm.yr_num = p_yr_num
622: and prm.prtt_prem_id = p_prtt_prem_id
623: order by prm.effective_start_date ;

Line 633: from ben_prtt_prem_by_mo_f prm

629: p_mo_num number,
630: p_yr_num number,
631: p_effective_dt date) is
632: select prm.prtt_prem_by_mo_id,prm.val,prm.cr_val,mnl_adj_flag, prm.object_version_number
633: from ben_prtt_prem_by_mo_f prm
634: where prm.mo_num = p_mo_num
635: and prm.yr_num = p_yr_num
636: and prm.prtt_prem_id = p_prtt_prem_id
637: and p_effective_dt between prm.effective_start_date and prm.effective_end_date;