APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ENRLD_ANTHR_PTIP_RT_F

Line 7675: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------

7671: ---------------------------------------------------------------
7672: -- END OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
7673: ---------------------------------------------------------------
7674: ---------------------------------------------------------------
7675: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
7676: ---------------------------------------------------------------
7677: cursor c_ent_from_parent(c_VRBL_RT_PRFL_ID number) is
7678: select enrld_anthr_ptip_rt_id
7679: from BEN_ENRLD_ANTHR_PTIP_RT_F

Line 7679: from BEN_ENRLD_ANTHR_PTIP_RT_F

7675: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
7676: ---------------------------------------------------------------
7677: cursor c_ent_from_parent(c_VRBL_RT_PRFL_ID number) is
7678: select enrld_anthr_ptip_rt_id
7679: from BEN_ENRLD_ANTHR_PTIP_RT_F
7680: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7681: --
7682: cursor c_ent(c_enrld_anthr_ptip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7683: select ent.*

Line 7684: from BEN_ENRLD_ANTHR_PTIP_RT_F ent

7680: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7681: --
7682: cursor c_ent(c_enrld_anthr_ptip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7683: select ent.*
7684: from BEN_ENRLD_ANTHR_PTIP_RT_F ent
7685: where ent.enrld_anthr_ptip_rt_id = c_enrld_anthr_ptip_rt_id
7686: --and ent.business_group_id = p_business_group_id
7687: and not exists (
7688: select /* */ null

Line 7695: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PTIP_RT_F'

7691: where copy_entity_txn_id = p_copy_entity_txn_id
7692: -- and trt.table_route_id = cpe.table_route_id
7693: and ( -- c_mirror_src_entity_result_id is null or
7694: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7695: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PTIP_RT_F'
7696: and cpe.table_alias = c_table_alias
7697: and information1 = c_enrld_anthr_ptip_rt_id
7698: -- and information4 = ent.business_group_id
7699: and information2 = ent.effective_start_date

Line 7704: -- END OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------

7700: and information3 = ent.effective_end_date);
7701: l_enrld_anthr_ptip_rt_id number(15);
7702: l_out_ent_result_id number(15);
7703: ---------------------------------------------------------------
7704: -- END OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
7705: ---------------------------------------------------------------
7706: ---------------------------------------------------------------
7707: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
7708: ---------------------------------------------------------------

Line 14259: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------

14255: ---------------------------------------------------------------
14256: -- END OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
14257: ---------------------------------------------------------------
14258: ---------------------------------------------------------------
14259: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
14260: ---------------------------------------------------------------
14261: --
14262: for l_parent_rec in c_ent_from_parent(l_VRBL_RT_PRFL_ID) loop
14263: --

Line 14358: -- END OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------

14354: end loop;
14355: --
14356: end loop;
14357: ---------------------------------------------------------------
14358: -- END OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
14359: ---------------------------------------------------------------
14360: ---------------------------------------------------------------
14361: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
14362: ---------------------------------------------------------------