APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_DPNT_CVRD_OTHR_PTIP_RT_F

Line 7483: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------

7479: ---------------------------------------------------------------
7480: -- END OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
7481: ---------------------------------------------------------------
7482: ---------------------------------------------------------------
7483: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
7484: ---------------------------------------------------------------
7485: cursor c_dco_from_parent(c_VRBL_RT_PRFL_ID number) is
7486: select dpnt_cvrd_othr_ptip_rt_id
7487: from BEN_DPNT_CVRD_OTHR_PTIP_RT_F

Line 7487: from BEN_DPNT_CVRD_OTHR_PTIP_RT_F

7483: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
7484: ---------------------------------------------------------------
7485: cursor c_dco_from_parent(c_VRBL_RT_PRFL_ID number) is
7486: select dpnt_cvrd_othr_ptip_rt_id
7487: from BEN_DPNT_CVRD_OTHR_PTIP_RT_F
7488: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7489: --
7490: cursor c_dco(c_dpnt_cvrd_othr_ptip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7491: select dco.*

Line 7492: from BEN_DPNT_CVRD_OTHR_PTIP_RT_F dco

7488: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7489: --
7490: cursor c_dco(c_dpnt_cvrd_othr_ptip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7491: select dco.*
7492: from BEN_DPNT_CVRD_OTHR_PTIP_RT_F dco
7493: where dco.dpnt_cvrd_othr_ptip_rt_id = c_dpnt_cvrd_othr_ptip_rt_id
7494: --and dco.business_group_id = p_business_group_id
7495: and not exists (
7496: select /* */ null

Line 7503: -- and trt.where_clause = 'BEN_DPNT_CVRD_OTHR_PTIP_RT_F'

7499: where copy_entity_txn_id = p_copy_entity_txn_id
7500: -- and trt.table_route_id = cpe.table_route_id
7501: and ( -- c_mirror_src_entity_result_id is null or
7502: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7503: -- and trt.where_clause = 'BEN_DPNT_CVRD_OTHR_PTIP_RT_F'
7504: and cpe.table_alias = c_table_alias
7505: and information1 = c_dpnt_cvrd_othr_ptip_rt_id
7506: -- and information4 = dco.business_group_id
7507: and information2 = dco.effective_start_date

Line 7512: -- END OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------

7508: and information3 = dco.effective_end_date);
7509: l_dpnt_cvrd_othr_ptip_rt_id number(15);
7510: l_out_dco_result_id number(15);
7511: ---------------------------------------------------------------
7512: -- END OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
7513: ---------------------------------------------------------------
7514: ---------------------------------------------------------------
7515: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
7516: ---------------------------------------------------------------

Line 13646: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------

13642: ---------------------------------------------------------------
13643: -- END OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
13644: ---------------------------------------------------------------
13645: ---------------------------------------------------------------
13646: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
13647: ---------------------------------------------------------------
13648: --
13649: for l_parent_rec in c_dco_from_parent(l_VRBL_RT_PRFL_ID) loop
13650: --

Line 13745: -- END OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------

13741: end loop;
13742: --
13743: end loop;
13744: ---------------------------------------------------------------
13745: -- END OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
13746: ---------------------------------------------------------------
13747: ---------------------------------------------------------------
13748: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
13749: ---------------------------------------------------------------