APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_DPNT_CVG_RQD_RLSHP_F

Line 12273: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------

12269: ---------------------------------------------------------------
12270: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
12271: ---------------------------------------------------------------
12272: ---------------------------------------------------------------
12273: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12274: ---------------------------------------------------------------
12275: cursor c_dcr_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12276: select dpnt_cvg_rqd_rlshp_id
12277: from BEN_DPNT_CVG_RQD_RLSHP_F

Line 12277: from BEN_DPNT_CVG_RQD_RLSHP_F

12273: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12274: ---------------------------------------------------------------
12275: cursor c_dcr_from_parent(c_DPNT_CVG_ELIGY_PRFL_ID number) is
12276: select dpnt_cvg_rqd_rlshp_id
12277: from BEN_DPNT_CVG_RQD_RLSHP_F
12278: where DPNT_CVG_ELIGY_PRFL_ID = c_DPNT_CVG_ELIGY_PRFL_ID ;
12279: --
12280: cursor c_dcr(c_dpnt_cvg_rqd_rlshp_id number,c_mirror_src_entity_result_id number ,
12281: c_table_alias varchar2 ) is

Line 12283: from BEN_DPNT_CVG_RQD_RLSHP_F dcr

12279: --
12280: cursor c_dcr(c_dpnt_cvg_rqd_rlshp_id number,c_mirror_src_entity_result_id number ,
12281: c_table_alias varchar2 ) is
12282: select dcr.*
12283: from BEN_DPNT_CVG_RQD_RLSHP_F dcr
12284: where dcr.dpnt_cvg_rqd_rlshp_id = c_dpnt_cvg_rqd_rlshp_id
12285: -- and dcr.business_group_id = p_business_group_id
12286: and not exists (
12287: select /* */ null

Line 12294: -- and trt.where_clause = 'BEN_DPNT_CVG_RQD_RLSHP_F'

12290: where copy_entity_txn_id = p_copy_entity_txn_id
12291: -- and trt.table_route_id = cpe.table_route_id
12292: and ( -- c_mirror_src_entity_result_id is null or
12293: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12294: -- and trt.where_clause = 'BEN_DPNT_CVG_RQD_RLSHP_F'
12295: and cpe.table_alias = c_table_alias
12296: and information1 = c_dpnt_cvg_rqd_rlshp_id
12297: -- and information4 = dcr.business_group_id
12298: and information2 = dcr.effective_start_date

Line 12304: -- END OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------

12300: );
12301: l_dpnt_cvg_rqd_rlshp_id number(15);
12302: l_out_dcr_result_id number(15);
12303: ---------------------------------------------------------------
12304: -- END OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12305: ---------------------------------------------------------------
12306: ---------------------------------------------------------------
12307: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12308: ---------------------------------------------------------------

Line 12765: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------

12761: --
12762:
12763: if l_out_dce_result_id is not null then
12764: ---------------------------------------------------------------
12765: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12766: ---------------------------------------------------------------
12767: --
12768: for l_parent_rec in c_dcr_from_parent(l_DPNT_CVG_ELIGY_PRFL_ID) loop
12769: --

Line 12891: -- END OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------

12887: end loop;
12888: --
12889: end loop;
12890: ---------------------------------------------------------------
12891: -- END OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
12892: ---------------------------------------------------------------
12893: ---------------------------------------------------------------
12894: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
12895: ---------------------------------------------------------------