DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ENRLD_ANTHR_PL_RT_F

Line 7611: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------

7607: ---------------------------------------------------------------
7608: -- END OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
7609: ---------------------------------------------------------------
7610: ---------------------------------------------------------------
7611: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
7612: ---------------------------------------------------------------
7613: cursor c_enl_from_parent(c_VRBL_RT_PRFL_ID number) is
7614: select enrld_anthr_pl_rt_id
7615: from BEN_ENRLD_ANTHR_PL_RT_F

Line 7615: from BEN_ENRLD_ANTHR_PL_RT_F

7611: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
7612: ---------------------------------------------------------------
7613: cursor c_enl_from_parent(c_VRBL_RT_PRFL_ID number) is
7614: select enrld_anthr_pl_rt_id
7615: from BEN_ENRLD_ANTHR_PL_RT_F
7616: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7617: --
7618: cursor c_enl(c_enrld_anthr_pl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7619: select enl.*

Line 7620: from BEN_ENRLD_ANTHR_PL_RT_F enl

7616: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7617: --
7618: cursor c_enl(c_enrld_anthr_pl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7619: select enl.*
7620: from BEN_ENRLD_ANTHR_PL_RT_F enl
7621: where enl.enrld_anthr_pl_rt_id = c_enrld_anthr_pl_rt_id
7622: --and enl.business_group_id = p_business_group_id
7623: and not exists (
7624: select /* */ null

Line 7631: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PL_RT_F'

7627: where copy_entity_txn_id = p_copy_entity_txn_id
7628: -- and trt.table_route_id = cpe.table_route_id
7629: and ( -- c_mirror_src_entity_result_id is null or
7630: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7631: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PL_RT_F'
7632: and cpe.table_alias = c_table_alias
7633: and information1 = c_enrld_anthr_pl_rt_id
7634: -- and information4 = enl.business_group_id
7635: and information2 = enl.effective_start_date

Line 7640: -- END OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------

7636: and information3 = enl.effective_end_date);
7637: l_enrld_anthr_pl_rt_id number(15);
7638: l_out_enl_result_id number(15);
7639: ---------------------------------------------------------------
7640: -- END OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
7641: ---------------------------------------------------------------
7642: ---------------------------------------------------------------
7643: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
7644: ---------------------------------------------------------------

Line 14055: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------

14051: ---------------------------------------------------------------
14052: -- END OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
14053: ---------------------------------------------------------------
14054: ---------------------------------------------------------------
14055: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
14056: ---------------------------------------------------------------
14057: --
14058: for l_parent_rec in c_enl_from_parent(l_VRBL_RT_PRFL_ID) loop
14059: --

Line 14154: -- END OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------

14150: end loop;
14151: --
14152: end loop;
14153: ---------------------------------------------------------------
14154: -- END OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
14155: ---------------------------------------------------------------
14156: ---------------------------------------------------------------
14157: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
14158: ---------------------------------------------------------------