APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ENRLD_ANTHR_OIPL_RT_F

Line 7579: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------

7575: ---------------------------------------------------------------
7576: -- END OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
7577: ---------------------------------------------------------------
7578: ---------------------------------------------------------------
7579: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
7580: ---------------------------------------------------------------
7581: cursor c_eao_from_parent(c_VRBL_RT_PRFL_ID number) is
7582: select enrld_anthr_oipl_rt_id
7583: from BEN_ENRLD_ANTHR_OIPL_RT_F

Line 7583: from BEN_ENRLD_ANTHR_OIPL_RT_F

7579: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
7580: ---------------------------------------------------------------
7581: cursor c_eao_from_parent(c_VRBL_RT_PRFL_ID number) is
7582: select enrld_anthr_oipl_rt_id
7583: from BEN_ENRLD_ANTHR_OIPL_RT_F
7584: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7585: --
7586: cursor c_eao(c_enrld_anthr_oipl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7587: select eao.*

Line 7588: from BEN_ENRLD_ANTHR_OIPL_RT_F eao

7584: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7585: --
7586: cursor c_eao(c_enrld_anthr_oipl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7587: select eao.*
7588: from BEN_ENRLD_ANTHR_OIPL_RT_F eao
7589: where eao.enrld_anthr_oipl_rt_id = c_enrld_anthr_oipl_rt_id
7590: --and eao.business_group_id = p_business_group_id
7591: and not exists (
7592: select /* */ null

Line 7599: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_OIPL_RT_F'

7595: where copy_entity_txn_id = p_copy_entity_txn_id
7596: -- and trt.table_route_id = cpe.table_route_id
7597: and ( -- c_mirror_src_entity_result_id is null or
7598: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7599: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_OIPL_RT_F'
7600: and cpe.table_alias = c_table_alias
7601: and information1 = c_enrld_anthr_oipl_rt_id
7602: -- and information4 = eao.business_group_id
7603: and information2 = eao.effective_start_date

Line 7608: -- END OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------

7604: and information3 = eao.effective_end_date);
7605: l_enrld_anthr_oipl_rt_id number(15);
7606: l_out_eao_result_id number(15);
7607: ---------------------------------------------------------------
7608: -- END OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
7609: ---------------------------------------------------------------
7610: ---------------------------------------------------------------
7611: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
7612: ---------------------------------------------------------------

Line 13953: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------

13949: ---------------------------------------------------------------
13950: -- END OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
13951: ---------------------------------------------------------------
13952: ---------------------------------------------------------------
13953: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
13954: ---------------------------------------------------------------
13955: --
13956: for l_parent_rec in c_eao_from_parent(l_VRBL_RT_PRFL_ID) loop
13957: --

Line 14052: -- END OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------

14048: end loop;
14049: --
14050: end loop;
14051: ---------------------------------------------------------------
14052: -- END OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
14053: ---------------------------------------------------------------
14054: ---------------------------------------------------------------
14055: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
14056: ---------------------------------------------------------------