APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ENRLD_ANTHR_PTIP_F

Line 1996: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------

1992: ---------------------------------------------------------------
1993: -- END OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
1994: ---------------------------------------------------------------
1995: ---------------------------------------------------------------
1996: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
1997: ---------------------------------------------------------------
1998: cursor c_eet_from_parent(c_ELIGY_PRFL_ID number) is
1999: select elig_enrld_anthr_ptip_id
2000: from BEN_ELIG_ENRLD_ANTHR_PTIP_F

Line 2000: from BEN_ELIG_ENRLD_ANTHR_PTIP_F

1996: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
1997: ---------------------------------------------------------------
1998: cursor c_eet_from_parent(c_ELIGY_PRFL_ID number) is
1999: select elig_enrld_anthr_ptip_id
2000: from BEN_ELIG_ENRLD_ANTHR_PTIP_F
2001: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2002: --
2003: cursor c_eet(c_elig_enrld_anthr_ptip_id number,c_mirror_src_entity_result_id number ,
2004: c_table_alias varchar2 ) is

Line 2006: from BEN_ELIG_ENRLD_ANTHR_PTIP_F eet

2002: --
2003: cursor c_eet(c_elig_enrld_anthr_ptip_id number,c_mirror_src_entity_result_id number ,
2004: c_table_alias varchar2 ) is
2005: select eet.*
2006: from BEN_ELIG_ENRLD_ANTHR_PTIP_F eet
2007: where eet.elig_enrld_anthr_ptip_id = c_elig_enrld_anthr_ptip_id
2008: -- and eet.business_group_id = p_business_group_id
2009: and not exists (
2010: select /* */ null

Line 2017: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PTIP_F'

2013: where copy_entity_txn_id = p_copy_entity_txn_id
2014: -- and trt.table_route_id = cpe.table_route_id
2015: and ( -- c_mirror_src_entity_result_id is null or
2016: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2017: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PTIP_F'
2018: and cpe.table_alias = c_table_alias
2019: and information1 = c_elig_enrld_anthr_ptip_id
2020: -- and information4 = eet.business_group_id
2021: and information2 = eet.effective_start_date

Line 2027: -- END OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------

2023: );
2024: l_elig_enrld_anthr_ptip_id number(15);
2025: l_out_eet_result_id number(15);
2026: ---------------------------------------------------------------
2027: -- END OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
2028: ---------------------------------------------------------------
2029: ---------------------------------------------------------------
2030: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
2031: ---------------------------------------------------------------

Line 6433: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------

6429: ---------------------------------------------------------------
6430: -- END OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
6431: ---------------------------------------------------------------
6432: ---------------------------------------------------------------
6433: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
6434: ---------------------------------------------------------------
6435: --
6436: for l_parent_rec in c_eet_from_parent(l_ELIGY_PRFL_ID) loop
6437: --

Line 6543: -- END OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------

6539: end loop;
6540: --
6541: end loop;
6542: ---------------------------------------------------------------
6543: -- END OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
6544: ---------------------------------------------------------------
6545: ---------------------------------------------------------------
6546: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
6547: ---------------------------------------------------------------