APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ENRLD_ANTHR_PGM_RT_F

Line 7707: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------

7703: ---------------------------------------------------------------
7704: -- END OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
7705: ---------------------------------------------------------------
7706: ---------------------------------------------------------------
7707: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
7708: ---------------------------------------------------------------
7709: cursor c_epm_from_parent(c_VRBL_RT_PRFL_ID number) is
7710: select enrld_anthr_pgm_rt_id
7711: from BEN_ENRLD_ANTHR_PGM_RT_F

Line 7711: from BEN_ENRLD_ANTHR_PGM_RT_F

7707: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
7708: ---------------------------------------------------------------
7709: cursor c_epm_from_parent(c_VRBL_RT_PRFL_ID number) is
7710: select enrld_anthr_pgm_rt_id
7711: from BEN_ENRLD_ANTHR_PGM_RT_F
7712: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7713: --
7714: cursor c_epm(c_enrld_anthr_pgm_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7715: select epm.*

Line 7716: from BEN_ENRLD_ANTHR_PGM_RT_F epm

7712: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7713: --
7714: cursor c_epm(c_enrld_anthr_pgm_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
7715: select epm.*
7716: from BEN_ENRLD_ANTHR_PGM_RT_F epm
7717: where epm.enrld_anthr_pgm_rt_id = c_enrld_anthr_pgm_rt_id
7718: --and epm.business_group_id = p_business_group_id
7719: and not exists (
7720: select /* */ null

Line 7727: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PGM_RT_F'

7723: where copy_entity_txn_id = p_copy_entity_txn_id
7724: -- and trt.table_route_id = cpe.table_route_id
7725: and ( -- c_mirror_src_entity_result_id is null or
7726: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7727: -- and trt.where_clause = 'BEN_ENRLD_ANTHR_PGM_RT_F'
7728: and cpe.table_alias = c_table_alias
7729: and information1 = c_enrld_anthr_pgm_rt_id
7730: -- and information4 = epm.business_group_id
7731: and information2 = epm.effective_start_date

Line 7736: -- END OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------

7732: and information3 = epm.effective_end_date);
7733: l_enrld_anthr_pgm_rt_id number(15);
7734: l_out_epm_result_id number(15);
7735: ---------------------------------------------------------------
7736: -- END OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
7737: ---------------------------------------------------------------
7738: ---------------------------------------------------------------
7739: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------
7740: ---------------------------------------------------------------

Line 14361: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------

14357: ---------------------------------------------------------------
14358: -- END OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
14359: ---------------------------------------------------------------
14360: ---------------------------------------------------------------
14361: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
14362: ---------------------------------------------------------------
14363: --
14364: for l_parent_rec in c_epm_from_parent(l_VRBL_RT_PRFL_ID) loop
14365: --

Line 14460: -- END OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------

14456: end loop;
14457: --
14458: end loop;
14459: ---------------------------------------------------------------
14460: -- END OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
14461: ---------------------------------------------------------------
14462: ---------------------------------------------------------------
14463: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------
14464: ---------------------------------------------------------------