APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_DPNT_CVRD_PLIP_RT_F

Line 7451: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------

7447: ---------------------------------------------------------------
7448: -- END OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
7449: ---------------------------------------------------------------
7450: ---------------------------------------------------------------
7451: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
7452: ---------------------------------------------------------------
7453: cursor c_dcp_from_parent(c_VRBL_RT_PRFL_ID number) is
7454: select dpnt_cvrd_plip_rt_id
7455: from BEN_DPNT_CVRD_PLIP_RT_F

Line 7455: from BEN_DPNT_CVRD_PLIP_RT_F

7451: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
7452: ---------------------------------------------------------------
7453: cursor c_dcp_from_parent(c_VRBL_RT_PRFL_ID number) is
7454: select dpnt_cvrd_plip_rt_id
7455: from BEN_DPNT_CVRD_PLIP_RT_F
7456: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7457: --
7458: cursor c_dcp(c_dpnt_cvrd_plip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7459: select dcp.*

Line 7460: from BEN_DPNT_CVRD_PLIP_RT_F dcp

7456: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7457: --
7458: cursor c_dcp(c_dpnt_cvrd_plip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7459: select dcp.*
7460: from BEN_DPNT_CVRD_PLIP_RT_F dcp
7461: where dcp.dpnt_cvrd_plip_rt_id = c_dpnt_cvrd_plip_rt_id
7462: --and dcp.business_group_id = p_business_group_id
7463: and not exists (
7464: select /* */ null

Line 7471: -- and trt.where_clause = 'BEN_DPNT_CVRD_PLIP_RT_F'

7467: where copy_entity_txn_id = p_copy_entity_txn_id
7468: -- and trt.table_route_id = cpe.table_route_id
7469: and ( -- c_mirror_src_entity_result_id is null or
7470: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7471: -- and trt.where_clause = 'BEN_DPNT_CVRD_PLIP_RT_F'
7472: and cpe.table_alias = c_table_alias
7473: and information1 = c_dpnt_cvrd_plip_rt_id
7474: -- and information4 = dcp.business_group_id
7475: and information2 = dcp.effective_start_date

Line 7480: -- END OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------

7476: and information3 = dcp.effective_end_date);
7477: l_dpnt_cvrd_plip_rt_id number(15);
7478: l_out_dcp_result_id number(15);
7479: ---------------------------------------------------------------
7480: -- END OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
7481: ---------------------------------------------------------------
7482: ---------------------------------------------------------------
7483: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
7484: ---------------------------------------------------------------

Line 13544: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------

13540: ---------------------------------------------------------------
13541: -- END OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
13542: ---------------------------------------------------------------
13543: ---------------------------------------------------------------
13544: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
13545: ---------------------------------------------------------------
13546: --
13547: for l_parent_rec in c_dcp_from_parent(l_VRBL_RT_PRFL_ID) loop
13548: --

Line 13643: -- END OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------

13639: end loop;
13640: --
13641: end loop;
13642: ---------------------------------------------------------------
13643: -- END OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
13644: ---------------------------------------------------------------
13645: ---------------------------------------------------------------
13646: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
13647: ---------------------------------------------------------------