APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ENRLD_ANTHR_PLIP_RT_F

Line 7643: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------

7639: ---------------------------------------------------------------
7640: -- END OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
7641: ---------------------------------------------------------------
7642: ---------------------------------------------------------------
7643: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
7644: ---------------------------------------------------------------
7645: cursor c_ear_from_parent(c_VRBL_RT_PRFL_ID number) is
7646: select enrld_anthr_plip_rt_id
7647: from BEN_ENRLD_ANTHR_PLIP_RT_F

Line 7647: from BEN_ENRLD_ANTHR_PLIP_RT_F

7643: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
7644: ---------------------------------------------------------------
7645: cursor c_ear_from_parent(c_VRBL_RT_PRFL_ID number) is
7646: select enrld_anthr_plip_rt_id
7647: from BEN_ENRLD_ANTHR_PLIP_RT_F
7648: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7649: --
7650: cursor c_ear(c_enrld_anthr_plip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7651: select ear.*

Line 7652: from BEN_ENRLD_ANTHR_PLIP_RT_F ear

7648: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7649: --
7650: cursor c_ear(c_enrld_anthr_plip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7651: select ear.*
7652: from BEN_ENRLD_ANTHR_PLIP_RT_F ear
7653: where ear.enrld_anthr_plip_rt_id = c_enrld_anthr_plip_rt_id
7654: --and ear.business_group_id = p_business_group_id
7655: and not exists (
7656: select /* */ null

Line 7663: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PLIP_RT_F'

7659: where copy_entity_txn_id = p_copy_entity_txn_id
7660: -- and trt.table_route_id = cpe.table_route_id
7661: and ( -- c_mirror_src_entity_result_id is null or
7662: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7663: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PLIP_RT_F'
7664: and cpe.table_alias = c_table_alias
7665: and information1 = c_enrld_anthr_plip_rt_id
7666: -- and information4 = ear.business_group_id
7667: and information2 = ear.effective_start_date

Line 7672: -- END OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------

7668: and information3 = ear.effective_end_date);
7669: l_enrld_anthr_plip_rt_id number(15);
7670: l_out_ear_result_id number(15);
7671: ---------------------------------------------------------------
7672: -- END OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
7673: ---------------------------------------------------------------
7674: ---------------------------------------------------------------
7675: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
7676: ---------------------------------------------------------------

Line 14157: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------

14153: ---------------------------------------------------------------
14154: -- END OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
14155: ---------------------------------------------------------------
14156: ---------------------------------------------------------------
14157: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
14158: ---------------------------------------------------------------
14159: --
14160: for l_parent_rec in c_ear_from_parent(l_VRBL_RT_PRFL_ID) loop
14161: --

Line 14256: -- END OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------

14252: end loop;
14253: --
14254: end loop;
14255: ---------------------------------------------------------------
14256: -- END OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
14257: ---------------------------------------------------------------
14258: ---------------------------------------------------------------
14259: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
14260: ---------------------------------------------------------------