APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PRTT_ANTHR_PL_RT_F

Line 7547: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------

7543: ---------------------------------------------------------------
7544: -- END OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
7545: ---------------------------------------------------------------
7546: ---------------------------------------------------------------
7547: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
7548: ---------------------------------------------------------------
7549: cursor c_pap_from_parent(c_VRBL_RT_PRFL_ID number) is
7550: select prtt_anthr_pl_rt_id
7551: from BEN_PRTT_ANTHR_PL_RT_F

Line 7551: from BEN_PRTT_ANTHR_PL_RT_F

7547: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
7548: ---------------------------------------------------------------
7549: cursor c_pap_from_parent(c_VRBL_RT_PRFL_ID number) is
7550: select prtt_anthr_pl_rt_id
7551: from BEN_PRTT_ANTHR_PL_RT_F
7552: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7553: --
7554: cursor c_pap(c_prtt_anthr_pl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7555: select pap.*

Line 7556: from BEN_PRTT_ANTHR_PL_RT_F pap

7552: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7553: --
7554: cursor c_pap(c_prtt_anthr_pl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7555: select pap.*
7556: from BEN_PRTT_ANTHR_PL_RT_F pap
7557: where pap.prtt_anthr_pl_rt_id = c_prtt_anthr_pl_rt_id
7558: --and pap.business_group_id = p_business_group_id
7559: and not exists (
7560: select /* */ null

Line 7567: -- and trt.where_clause = 'BEN_PRTT_ANTHR_PL_RT_F'

7563: where copy_entity_txn_id = p_copy_entity_txn_id
7564: -- and trt.table_route_id = cpe.table_route_id
7565: and ( -- c_mirror_src_entity_result_id is null or
7566: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7567: -- and trt.where_clause = 'BEN_PRTT_ANTHR_PL_RT_F'
7568: and cpe.table_alias = c_table_alias
7569: and information1 = c_prtt_anthr_pl_rt_id
7570: -- and information4 = pap.business_group_id
7571: and information2 = pap.effective_start_date

Line 7576: -- END OF BEN_PRTT_ANTHR_PL_RT_F ----------------------

7572: and information3 = pap.effective_end_date);
7573: l_prtt_anthr_pl_rt_id number(15);
7574: l_out_pap_result_id number(15);
7575: ---------------------------------------------------------------
7576: -- END OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
7577: ---------------------------------------------------------------
7578: ---------------------------------------------------------------
7579: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
7580: ---------------------------------------------------------------

Line 13851: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------

13847: ---------------------------------------------------------------
13848: -- END OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
13849: ---------------------------------------------------------------
13850: ---------------------------------------------------------------
13851: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
13852: ---------------------------------------------------------------
13853: --
13854: for l_parent_rec in c_pap_from_parent(l_VRBL_RT_PRFL_ID) loop
13855: --

Line 13950: -- END OF BEN_PRTT_ANTHR_PL_RT_F ----------------------

13946: end loop;
13947: --
13948: end loop;
13949: ---------------------------------------------------------------
13950: -- END OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
13951: ---------------------------------------------------------------
13952: ---------------------------------------------------------------
13953: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
13954: ---------------------------------------------------------------