APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_ELIGY_PRFL_F

Line 1116: ,ben_eligy_prfl_f elp

1112: EXISTS
1113: (SELECT NULL
1114: FROM ben_prtn_elig_f epa2
1115: ,ben_prtn_elig_prfl_f cep
1116: ,ben_eligy_prfl_f elp
1117: WHERE epa2.pl_id = cpp.pl_id
1118: AND epa2.business_group_id =
1119: cpp.business_group_id
1120: AND p_effective_date BETWEEN epa2.effective_start_date

Line 1210: ,ben_eligy_prfl_f elp

1206: EXISTS
1207: (SELECT NULL
1208: FROM ben_prtn_elig_f epa2
1209: ,ben_prtn_elig_prfl_f cep
1210: ,ben_eligy_prfl_f elp
1211: WHERE epa2.oipl_id = cop.oipl_id
1212: AND epa2.business_group_id =
1213: cop.business_group_id
1214: AND p_effective_date BETWEEN epa2.effective_start_date

Line 1306: ,ben_eligy_prfl_f elp

1302: EXISTS
1303: (SELECT NULL
1304: FROM ben_prtn_elig_f epa2
1305: ,ben_prtn_elig_prfl_f cep
1306: ,ben_eligy_prfl_f elp
1307: WHERE epa2.pgm_id = pgm.pgm_id
1308: AND epa2.business_group_id = pgm.business_group_id
1309: AND p_effective_date BETWEEN epa2.effective_start_date
1310: AND epa2.effective_end_date

Line 1515: ,ben_eligy_prfl_f elp

1511: EXISTS
1512: (SELECT NULL
1513: FROM ben_prtn_elig_f epa2
1514: ,ben_prtn_elig_prfl_f cep
1515: ,ben_eligy_prfl_f elp
1516: WHERE epa2.pl_id = pln.pl_id
1517: AND epa2.business_group_id = pln.business_group_id
1518: AND p_effective_date BETWEEN epa2.effective_start_date
1519: AND epa2.effective_end_date

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

1911: l_tabname_set(6) := 'ben_oiplip_f';
1912: --
1913: l_tabname_set(7) := 'ben_prtn_elig_f';
1914: l_tabname_set(8) := 'ben_prtn_elig_prfl_f';
1915: l_tabname_set(9) := 'ben_eligy_prfl_f';
1916: --
1917: l_tabname_set(10) := 'ben_popl_yr_perd';
1918: l_tabname_set(11) := 'ben_yr_perd';
1919: l_tabname_set(12) := 'ben_rptg_grp';