APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_OPTD_MDCR_RT_F

Line 7771: -- START OF BEN_OPTD_MDCR_RT_F ----------------------

7767: ---------------------------------------------------------------
7768: -- END OF BEN_NO_OTHR_CVG_RT_F ----------------------
7769: ---------------------------------------------------------------
7770: ---------------------------------------------------------------
7771: -- START OF BEN_OPTD_MDCR_RT_F ----------------------
7772: ---------------------------------------------------------------
7773: cursor c_omr_from_parent(c_VRBL_RT_PRFL_ID number) is
7774: select optd_mdcr_rt_id
7775: from BEN_OPTD_MDCR_RT_F

Line 7775: from BEN_OPTD_MDCR_RT_F

7771: -- START OF BEN_OPTD_MDCR_RT_F ----------------------
7772: ---------------------------------------------------------------
7773: cursor c_omr_from_parent(c_VRBL_RT_PRFL_ID number) is
7774: select optd_mdcr_rt_id
7775: from BEN_OPTD_MDCR_RT_F
7776: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7777: --
7778: cursor c_omr(c_optd_mdcr_rt_id number,c_mirror_src_entity_result_id number,
7779: c_table_alias varchar2 ) is

Line 7781: from BEN_OPTD_MDCR_RT_F omr

7777: --
7778: cursor c_omr(c_optd_mdcr_rt_id number,c_mirror_src_entity_result_id number,
7779: c_table_alias varchar2 ) is
7780: select omr.*
7781: from BEN_OPTD_MDCR_RT_F omr
7782: where omr.optd_mdcr_rt_id = c_optd_mdcr_rt_id
7783: --and omr.business_group_id = p_business_group_id
7784: and not exists (
7785: select /* */ null

Line 7792: -- and trt.where_clause = 'BEN_OPTD_MDCR_RT_F'

7788: where copy_entity_txn_id = p_copy_entity_txn_id
7789: -- and trt.table_route_id = cpe.table_route_id
7790: and ( -- c_mirror_src_entity_result_id is null or
7791: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7792: -- and trt.where_clause = 'BEN_OPTD_MDCR_RT_F'
7793: and cpe.table_alias = c_table_alias
7794: and information1 = c_optd_mdcr_rt_id
7795: -- and information4 = omr.business_group_id
7796: and information2 = omr.effective_start_date

Line 7801: -- END OF BEN_OPTD_MDCR_RT_F ----------------------

7797: and information3 = omr.effective_end_date);
7798: l_optd_mdcr_rt_id number(15);
7799: l_out_omr_result_id number(15);
7800: ---------------------------------------------------------------
7801: -- END OF BEN_OPTD_MDCR_RT_F ----------------------
7802: ---------------------------------------------------------------
7803: ---------------------------------------------------------------
7804: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
7805: ---------------------------------------------------------------

Line 14562: -- START OF BEN_OPTD_MDCR_RT_F ----------------------

14558: ---------------------------------------------------------------
14559: -- END OF BEN_NO_OTHR_CVG_RT_F ----------------------
14560: ---------------------------------------------------------------
14561: ---------------------------------------------------------------
14562: -- START OF BEN_OPTD_MDCR_RT_F ----------------------
14563: ---------------------------------------------------------------
14564: --
14565: for l_parent_rec in c_omr_from_parent(l_VRBL_RT_PRFL_ID) loop
14566: --

Line 14659: -- END OF BEN_OPTD_MDCR_RT_F ----------------------

14655: end loop;
14656: --
14657: end loop;
14658: ---------------------------------------------------------------
14659: -- END OF BEN_OPTD_MDCR_RT_F ----------------------
14660: ---------------------------------------------------------------
14661: ---------------------------------------------------------------
14662: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
14663: ---------------------------------------------------------------