APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 12307: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------

12303: ---------------------------------------------------------------
12304: -- END OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12305: ---------------------------------------------------------------
12306: ---------------------------------------------------------------
12307: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12308: ---------------------------------------------------------------
12309: cursor c_dpc_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12310: select dpnt_cvrd_anthr_pl_cvg_id
12311: from BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 12311: from BEN_DPNT_CVRD_ANTHR_PL_CVG_F

12307: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12308: ---------------------------------------------------------------
12309: cursor c_dpc_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12310: select dpnt_cvrd_anthr_pl_cvg_id
12311: from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
12312: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12313: --
12314: cursor c_dpc(c_dpnt_cvrd_anthr_pl_cvg_id number,c_mirror_src_entity_result_id number ,
12315: c_table_alias varchar2 ) is

Line 12317: from BEN_DPNT_CVRD_ANTHR_PL_CVG_F dpc

12313: --
12314: cursor c_dpc(c_dpnt_cvrd_anthr_pl_cvg_id number,c_mirror_src_entity_result_id number ,
12315: c_table_alias varchar2 ) is
12316: select dpc.*
12317: from BEN_DPNT_CVRD_ANTHR_PL_CVG_F dpc
12318: where dpc.dpnt_cvrd_anthr_pl_cvg_id = c_dpnt_cvrd_anthr_pl_cvg_id
12319: -- and dpc.business_group_id = p_business_group_id
12320: and not exists (
12321: select /* */ null

Line 12328: -- and trt.where_clause = 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F'

12324: where copy_entity_txn_id = p_copy_entity_txn_id
12325: -- and trt.table_route_id = cpe.table_route_id
12326: and ( -- c_mirror_src_entity_result_id is null or
12327: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12328: -- and trt.where_clause = 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F'
12329: and cpe.table_alias = c_table_alias
12330: and information1 = c_dpnt_cvrd_anthr_pl_cvg_id
12331: -- and information4 = dpc.business_group_id
12332: and information2 = dpc.effective_start_date

Line 12338: -- END OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------

12334: );
12335: l_dpnt_cvrd_anthr_pl_cvg_id number(15);
12336: l_out_dpc_result_id number(15);
12337: ---------------------------------------------------------------
12338: -- END OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12339: ---------------------------------------------------------------
12340: ---------------------------------------------------------------
12341: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
12342: ---------------------------------------------------------------

Line 12894: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------

12890: ---------------------------------------------------------------
12891: -- END OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12892: ---------------------------------------------------------------
12893: ---------------------------------------------------------------
12894: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12895: ---------------------------------------------------------------
12896: --
12897: for l_parent_rec in c_dpc_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
12898: --

Line 12996: -- END OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------

12992: end loop;
12993: --
12994: end loop;
12995: ---------------------------------------------------------------
12996: -- END OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12997: ---------------------------------------------------------------
12998: ---------------------------------------------------------------
12999: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
13000: ---------------------------------------------------------------