APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_ELIGY_PRFL_F

Line 1131: ,ben_eligy_prfl_f elp

1127: EXISTS
1128: (SELECT NULL
1129: FROM ben_prtn_elig_f epa2
1130: ,ben_prtn_elig_prfl_f cep
1131: ,ben_eligy_prfl_f elp
1132: WHERE epa2.pl_id = cpp.pl_id
1133: AND epa2.business_group_id =
1134: cpp.business_group_id
1135: AND p_effective_date BETWEEN epa2.effective_start_date

Line 1225: ,ben_eligy_prfl_f elp

1221: EXISTS
1222: (SELECT NULL
1223: FROM ben_prtn_elig_f epa2
1224: ,ben_prtn_elig_prfl_f cep
1225: ,ben_eligy_prfl_f elp
1226: WHERE epa2.oipl_id = cop.oipl_id
1227: AND epa2.business_group_id =
1228: cop.business_group_id
1229: AND p_effective_date BETWEEN epa2.effective_start_date

Line 1321: ,ben_eligy_prfl_f elp

1317: EXISTS
1318: (SELECT NULL
1319: FROM ben_prtn_elig_f epa2
1320: ,ben_prtn_elig_prfl_f cep
1321: ,ben_eligy_prfl_f elp
1322: WHERE epa2.pgm_id = pgm.pgm_id
1323: AND epa2.business_group_id = pgm.business_group_id
1324: AND p_effective_date BETWEEN epa2.effective_start_date
1325: AND epa2.effective_end_date

Line 1530: ,ben_eligy_prfl_f elp

1526: EXISTS
1527: (SELECT NULL
1528: FROM ben_prtn_elig_f epa2
1529: ,ben_prtn_elig_prfl_f cep
1530: ,ben_eligy_prfl_f elp
1531: WHERE epa2.pl_id = pln.pl_id
1532: AND epa2.business_group_id = pln.business_group_id
1533: AND p_effective_date BETWEEN epa2.effective_start_date
1534: AND epa2.effective_end_date

Line 1933: l_tabname_set(9) := 'ben_eligy_prfl_f';

1929: l_tabname_set(6) := 'ben_oiplip_f';
1930: --
1931: l_tabname_set(7) := 'ben_prtn_elig_f';
1932: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';
1933: l_tabname_set(9) := 'ben_eligy_prfl_f';
1934: --
1935: l_tabname_set(10) := 'ben_popl_yr_perd';
1936: l_tabname_set(11) := 'ben_yr_perd';
1937: l_tabname_set(12) := 'ben_rptg_grp';