APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ENRLD_ANTHR_PL_F

Line 1962: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------

1958: ---------------------------------------------------------------
1959: -- END OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
1960: ---------------------------------------------------------------
1961: ---------------------------------------------------------------
1962: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
1963: ---------------------------------------------------------------
1964: cursor c_eep_from_parent(c_ELIGY_PRFL_ID number) is
1965: select elig_enrld_anthr_pl_id
1966: from BEN_ELIG_ENRLD_ANTHR_PL_F

Line 1966: from BEN_ELIG_ENRLD_ANTHR_PL_F

1962: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
1963: ---------------------------------------------------------------
1964: cursor c_eep_from_parent(c_ELIGY_PRFL_ID number) is
1965: select elig_enrld_anthr_pl_id
1966: from BEN_ELIG_ENRLD_ANTHR_PL_F
1967: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1968: --
1969: cursor c_eep(c_elig_enrld_anthr_pl_id number,c_mirror_src_entity_result_id number ,
1970: c_table_alias varchar2 ) is

Line 1972: from BEN_ELIG_ENRLD_ANTHR_PL_F eep

1968: --
1969: cursor c_eep(c_elig_enrld_anthr_pl_id number,c_mirror_src_entity_result_id number ,
1970: c_table_alias varchar2 ) is
1971: select eep.*
1972: from BEN_ELIG_ENRLD_ANTHR_PL_F eep
1973: where eep.elig_enrld_anthr_pl_id = c_elig_enrld_anthr_pl_id
1974: -- and eep.business_group_id = p_business_group_id
1975: and not exists (
1976: select /* */ null

Line 1983: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PL_F'

1979: where copy_entity_txn_id = p_copy_entity_txn_id
1980: -- and trt.table_route_id = cpe.table_route_id
1981: and ( -- c_mirror_src_entity_result_id is null or
1982: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1983: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PL_F'
1984: and cpe.table_alias = c_table_alias
1985: and information1 = c_elig_enrld_anthr_pl_id
1986: -- and information4 = eep.business_group_id
1987: and information2 = eep.effective_start_date

Line 1993: -- END OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------

1989: );
1990: l_elig_enrld_anthr_pl_id number(15);
1991: l_out_eep_result_id number(15);
1992: ---------------------------------------------------------------
1993: -- END OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
1994: ---------------------------------------------------------------
1995: ---------------------------------------------------------------
1996: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
1997: ---------------------------------------------------------------

Line 6323: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------

6319: ---------------------------------------------------------------
6320: -- END OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
6321: ---------------------------------------------------------------
6322: ---------------------------------------------------------------
6323: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
6324: ---------------------------------------------------------------
6325: --
6326: for l_parent_rec in c_eep_from_parent(l_ELIGY_PRFL_ID) loop
6327: --

Line 6430: -- END OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------

6426: end loop;
6427: --
6428: end loop;
6429: ---------------------------------------------------------------
6430: -- END OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
6431: ---------------------------------------------------------------
6432: ---------------------------------------------------------------
6433: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
6434: ---------------------------------------------------------------