APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PRTN_ELIG_PRFL_F

Line 1130: ,ben_prtn_elig_prfl_f cep

1126: AND (
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

Line 1224: ,ben_prtn_elig_prfl_f cep

1220: AND (
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

Line 1320: ,ben_prtn_elig_prfl_f cep

1316: AND (
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

Line 1529: ,ben_prtn_elig_prfl_f cep

1525: AND (
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

Line 1932: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';

1928: l_tabname_set(5) := 'ben_oipl_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';