APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_CBR_QUALD_BNF_RT_F

Line 7355: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------

7351: ---------------------------------------------------------------
7352: -- END OF BEN_QUAL_TITL_RT_F ----------------------
7353: ---------------------------------------------------------------
7354: ---------------------------------------------------------------
7355: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------
7356: ---------------------------------------------------------------
7357: cursor c_cqr_from_parent(c_VRBL_RT_PRFL_ID number) is
7358: select cbr_quald_bnf_rt_id
7359: from BEN_CBR_QUALD_BNF_RT_F

Line 7359: from BEN_CBR_QUALD_BNF_RT_F

7355: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------
7356: ---------------------------------------------------------------
7357: cursor c_cqr_from_parent(c_VRBL_RT_PRFL_ID number) is
7358: select cbr_quald_bnf_rt_id
7359: from BEN_CBR_QUALD_BNF_RT_F
7360: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7361: --
7362: cursor c_cqr(c_cbr_quald_bnf_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7363: select cqr.*

Line 7364: from BEN_CBR_QUALD_BNF_RT_F cqr

7360: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7361: --
7362: cursor c_cqr(c_cbr_quald_bnf_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7363: select cqr.*
7364: from BEN_CBR_QUALD_BNF_RT_F cqr
7365: where cqr.cbr_quald_bnf_rt_id = c_cbr_quald_bnf_rt_id
7366: --and cqr.business_group_id = p_business_group_id
7367: and not exists (
7368: select /* */ null

Line 7375: -- and trt.where_clause = 'BEN_CBR_QUALD_BNF_RT_F'

7371: where copy_entity_txn_id = p_copy_entity_txn_id
7372: -- and trt.table_route_id = cpe.table_route_id
7373: and ( -- c_mirror_src_entity_result_id is null or
7374: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7375: -- and trt.where_clause = 'BEN_CBR_QUALD_BNF_RT_F'
7376: and cpe.table_alias = c_table_alias
7377: and information1 = c_cbr_quald_bnf_rt_id
7378: -- and information4 = cqr.business_group_id
7379: and information2 = cqr.effective_start_date

Line 7384: -- END OF BEN_CBR_QUALD_BNF_RT_F ----------------------

7380: and information3 = cqr.effective_end_date);
7381: l_cbr_quald_bnf_rt_id number(15);
7382: l_out_cqr_result_id number(15);
7383: ---------------------------------------------------------------
7384: -- END OF BEN_CBR_QUALD_BNF_RT_F ----------------------
7385: ---------------------------------------------------------------
7386: ---------------------------------------------------------------
7387: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
7388: ---------------------------------------------------------------

Line 13218: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------

13214: ---------------------------------------------------------------
13215: -- END OF BEN_QUAL_TITL_RT_F ----------------------
13216: ---------------------------------------------------------------
13217: ---------------------------------------------------------------
13218: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------
13219: ---------------------------------------------------------------
13220: --
13221: for l_parent_rec in c_cqr_from_parent(l_VRBL_RT_PRFL_ID) loop
13222: --

Line 13317: -- END OF BEN_CBR_QUALD_BNF_RT_F ----------------------

13313: end loop;
13314: --
13315: end loop;
13316: ---------------------------------------------------------------
13317: -- END OF BEN_CBR_QUALD_BNF_RT_F ----------------------
13318: ---------------------------------------------------------------
13319: ---------------------------------------------------------------
13320: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
13321: ---------------------------------------------------------------