APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ENRLD_ANTHR_PLIP_F

Line 1928: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------

1924: ---------------------------------------------------------------
1925: -- END OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
1926: ---------------------------------------------------------------
1927: ---------------------------------------------------------------
1928: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
1929: ---------------------------------------------------------------
1930: cursor c_eai_from_parent(c_ELIGY_PRFL_ID number) is
1931: select elig_enrld_anthr_plip_id
1932: from BEN_ELIG_ENRLD_ANTHR_PLIP_F

Line 1932: from BEN_ELIG_ENRLD_ANTHR_PLIP_F

1928: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
1929: ---------------------------------------------------------------
1930: cursor c_eai_from_parent(c_ELIGY_PRFL_ID number) is
1931: select elig_enrld_anthr_plip_id
1932: from BEN_ELIG_ENRLD_ANTHR_PLIP_F
1933: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1934: --
1935: cursor c_eai(c_elig_enrld_anthr_plip_id number,c_mirror_src_entity_result_id number ,
1936: c_table_alias varchar2 ) is

Line 1938: from BEN_ELIG_ENRLD_ANTHR_PLIP_F eai

1934: --
1935: cursor c_eai(c_elig_enrld_anthr_plip_id number,c_mirror_src_entity_result_id number ,
1936: c_table_alias varchar2 ) is
1937: select eai.*
1938: from BEN_ELIG_ENRLD_ANTHR_PLIP_F eai
1939: where eai.elig_enrld_anthr_plip_id = c_elig_enrld_anthr_plip_id
1940: -- and eai.business_group_id = p_business_group_id
1941: and not exists (
1942: select /* */ null

Line 1949: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PLIP_F'

1945: where copy_entity_txn_id = p_copy_entity_txn_id
1946: -- and trt.table_route_id = cpe.table_route_id
1947: and ( -- c_mirror_src_entity_result_id is null or
1948: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1949: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PLIP_F'
1950: and cpe.table_alias = c_table_alias
1951: and information1 = c_elig_enrld_anthr_plip_id
1952: -- and information4 = eai.business_group_id
1953: and information2 = eai.effective_start_date

Line 1959: -- END OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------

1955: );
1956: l_elig_enrld_anthr_plip_id number(15);
1957: l_out_eai_result_id number(15);
1958: ---------------------------------------------------------------
1959: -- END OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
1960: ---------------------------------------------------------------
1961: ---------------------------------------------------------------
1962: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
1963: ---------------------------------------------------------------

Line 6213: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------

6209: ---------------------------------------------------------------
6210: -- END OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
6211: ---------------------------------------------------------------
6212: ---------------------------------------------------------------
6213: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
6214: ---------------------------------------------------------------
6215: --
6216: for l_parent_rec in c_eai_from_parent(l_ELIGY_PRFL_ID) loop
6217: --

Line 6320: -- END OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------

6316: end loop;
6317: --
6318: end loop;
6319: ---------------------------------------------------------------
6320: -- END OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
6321: ---------------------------------------------------------------
6322: ---------------------------------------------------------------
6323: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
6324: ---------------------------------------------------------------