APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 1894: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------

1890: ---------------------------------------------------------------
1891: -- END OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
1892: ---------------------------------------------------------------
1893: ---------------------------------------------------------------
1894: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
1895: ---------------------------------------------------------------
1896: cursor c_eeg_from_parent(c_ELIGY_PRFL_ID number) is
1897: select elig_enrld_anthr_pgm_id
1898: from BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 1898: from BEN_ELIG_ENRLD_ANTHR_PGM_F

1894: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
1895: ---------------------------------------------------------------
1896: cursor c_eeg_from_parent(c_ELIGY_PRFL_ID number) is
1897: select elig_enrld_anthr_pgm_id
1898: from BEN_ELIG_ENRLD_ANTHR_PGM_F
1899: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1900: --
1901: cursor c_eeg(c_elig_enrld_anthr_pgm_id number,c_mirror_src_entity_result_id number ,
1902: c_table_alias varchar2 ) is

Line 1904: from BEN_ELIG_ENRLD_ANTHR_PGM_F eeg

1900: --
1901: cursor c_eeg(c_elig_enrld_anthr_pgm_id number,c_mirror_src_entity_result_id number ,
1902: c_table_alias varchar2 ) is
1903: select eeg.*
1904: from BEN_ELIG_ENRLD_ANTHR_PGM_F eeg
1905: where eeg.elig_enrld_anthr_pgm_id = c_elig_enrld_anthr_pgm_id
1906: -- and eeg.business_group_id = p_business_group_id
1907: and not exists (
1908: select /* */ null

Line 1915: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PGM_F'

1911: where copy_entity_txn_id = p_copy_entity_txn_id
1912: -- and trt.table_route_id = cpe.table_route_id
1913: and ( -- c_mirror_src_entity_result_id is null or
1914: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1915: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_PGM_F'
1916: and cpe.table_alias = c_table_alias
1917: and information1 = c_elig_enrld_anthr_pgm_id
1918: -- and information4 = eeg.business_group_id
1919: and information2 = eeg.effective_start_date

Line 1925: -- END OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------

1921: );
1922: l_elig_enrld_anthr_pgm_id number(15);
1923: l_out_eeg_result_id number(15);
1924: ---------------------------------------------------------------
1925: -- END OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
1926: ---------------------------------------------------------------
1927: ---------------------------------------------------------------
1928: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
1929: ---------------------------------------------------------------

Line 6103: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------

6099: ---------------------------------------------------------------
6100: -- END OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
6101: ---------------------------------------------------------------
6102: ---------------------------------------------------------------
6103: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
6104: ---------------------------------------------------------------
6105: --
6106: for l_parent_rec in c_eeg_from_parent(l_ELIGY_PRFL_ID) loop
6107: --

Line 6210: -- END OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------

6206: end loop;
6207: --
6208: end loop;
6209: ---------------------------------------------------------------
6210: -- END OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
6211: ---------------------------------------------------------------
6212: ---------------------------------------------------------------
6213: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
6214: ---------------------------------------------------------------