APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_CNTNG_PRTN_PRFL_RT_F

Line 7387: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------

7383: ---------------------------------------------------------------
7384: -- END OF BEN_CBR_QUALD_BNF_RT_F ----------------------
7385: ---------------------------------------------------------------
7386: ---------------------------------------------------------------
7387: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
7388: ---------------------------------------------------------------
7389: cursor c_cpn_from_parent(c_VRBL_RT_PRFL_ID number) is
7390: select cntng_prtn_prfl_rt_id
7391: from BEN_CNTNG_PRTN_PRFL_RT_F

Line 7391: from BEN_CNTNG_PRTN_PRFL_RT_F

7387: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
7388: ---------------------------------------------------------------
7389: cursor c_cpn_from_parent(c_VRBL_RT_PRFL_ID number) is
7390: select cntng_prtn_prfl_rt_id
7391: from BEN_CNTNG_PRTN_PRFL_RT_F
7392: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7393: --
7394: cursor c_cpn(c_cntng_prtn_prfl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7395: select cpn.*

Line 7396: from BEN_CNTNG_PRTN_PRFL_RT_F cpn

7392: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7393: --
7394: cursor c_cpn(c_cntng_prtn_prfl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7395: select cpn.*
7396: from BEN_CNTNG_PRTN_PRFL_RT_F cpn
7397: where cpn.cntng_prtn_prfl_rt_id = c_cntng_prtn_prfl_rt_id
7398: --and cpn.business_group_id = p_business_group_id
7399: and not exists (
7400: select /* */ null

Line 7407: -- and trt.where_clause = 'BEN_CNTNG_PRTN_PRFL_RT_F'

7403: where copy_entity_txn_id = p_copy_entity_txn_id
7404: -- and trt.table_route_id = cpe.table_route_id
7405: and ( -- c_mirror_src_entity_result_id is null or
7406: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7407: -- and trt.where_clause = 'BEN_CNTNG_PRTN_PRFL_RT_F'
7408: and cpe.table_alias = c_table_alias
7409: and information1 = c_cntng_prtn_prfl_rt_id
7410: -- and information4 = cpn.business_group_id
7411: and information2 = cpn.effective_start_date

Line 7416: -- END OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------

7412: and information3 = cpn.effective_end_date);
7413: l_cntng_prtn_prfl_rt_id number(15);
7414: l_out_cpn_result_id number(15);
7415: ---------------------------------------------------------------
7416: -- END OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
7417: ---------------------------------------------------------------
7418: ---------------------------------------------------------------
7419: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
7420: ---------------------------------------------------------------

Line 13320: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------

13316: ---------------------------------------------------------------
13317: -- END OF BEN_CBR_QUALD_BNF_RT_F ----------------------
13318: ---------------------------------------------------------------
13319: ---------------------------------------------------------------
13320: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
13321: ---------------------------------------------------------------
13322: --
13323: for l_parent_rec in c_cpn_from_parent(l_VRBL_RT_PRFL_ID) loop
13324: --

Line 13440: -- END OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------

13436: end loop;
13437: --
13438: end loop;
13439: ---------------------------------------------------------------
13440: -- END OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
13441: ---------------------------------------------------------------
13442: ---------------------------------------------------------------
13443: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
13444: ---------------------------------------------------------------