APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_DPNT_CVRD_OTHR_PL_RT_F

Line 7419: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------

7415: ---------------------------------------------------------------
7416: -- END OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
7417: ---------------------------------------------------------------
7418: ---------------------------------------------------------------
7419: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
7420: ---------------------------------------------------------------
7421: cursor c_dcl_from_parent(c_VRBL_RT_PRFL_ID number) is
7422: select dpnt_cvrd_othr_pl_rt_id
7423: from BEN_DPNT_CVRD_OTHR_PL_RT_F

Line 7423: from BEN_DPNT_CVRD_OTHR_PL_RT_F

7419: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
7420: ---------------------------------------------------------------
7421: cursor c_dcl_from_parent(c_VRBL_RT_PRFL_ID number) is
7422: select dpnt_cvrd_othr_pl_rt_id
7423: from BEN_DPNT_CVRD_OTHR_PL_RT_F
7424: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7425: --
7426: cursor c_dcl(c_dpnt_cvrd_othr_pl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7427: select dcl.*

Line 7428: from BEN_DPNT_CVRD_OTHR_PL_RT_F dcl

7424: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7425: --
7426: cursor c_dcl(c_dpnt_cvrd_othr_pl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7427: select dcl.*
7428: from BEN_DPNT_CVRD_OTHR_PL_RT_F dcl
7429: where dcl.dpnt_cvrd_othr_pl_rt_id = c_dpnt_cvrd_othr_pl_rt_id
7430: --and dcl.business_group_id = p_business_group_id
7431: and not exists (
7432: select /* */ null

Line 7439: -- and trt.where_clause = 'BEN_DPNT_CVRD_OTHR_PL_RT_F'

7435: where copy_entity_txn_id = p_copy_entity_txn_id
7436: -- and trt.table_route_id = cpe.table_route_id
7437: and ( -- c_mirror_src_entity_result_id is null or
7438: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7439: -- and trt.where_clause = 'BEN_DPNT_CVRD_OTHR_PL_RT_F'
7440: and cpe.table_alias = c_table_alias
7441: and information1 = c_dpnt_cvrd_othr_pl_rt_id
7442: -- and information4 = dcl.business_group_id
7443: and information2 = dcl.effective_start_date

Line 7448: -- END OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------

7444: and information3 = dcl.effective_end_date);
7445: l_dpnt_cvrd_othr_pl_rt_id number(15);
7446: l_out_dcl_result_id number(15);
7447: ---------------------------------------------------------------
7448: -- END OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
7449: ---------------------------------------------------------------
7450: ---------------------------------------------------------------
7451: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
7452: ---------------------------------------------------------------

Line 13443: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------

13439: ---------------------------------------------------------------
13440: -- END OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
13441: ---------------------------------------------------------------
13442: ---------------------------------------------------------------
13443: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
13444: ---------------------------------------------------------------
13445: --
13446: for l_parent_rec in c_dcl_from_parent(l_VRBL_RT_PRFL_ID) loop
13447: --

Line 13541: -- END OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------

13537: end loop;
13538: --
13539: end loop;
13540: ---------------------------------------------------------------
13541: -- END OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
13542: ---------------------------------------------------------------
13543: ---------------------------------------------------------------
13544: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
13545: ---------------------------------------------------------------