APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PRTN_ELIG_F

Line 1028: l_epa ben_prtn_elig_f%ROWTYPE;

1024: l_plip ben_plip_f%ROWTYPE;
1025: l_ptip ben_ptip_f%ROWTYPE;
1026: l_opt ben_opt_f%ROWTYPE;
1027: l_oiplip ben_oiplip_f%ROWTYPE;
1028: l_epa ben_prtn_elig_f%ROWTYPE;
1029: l_plnnip_set ben_pln_cache.g_nipplnpln_cache;
1030: l_inst_count NUMBER;
1031: l_plnrow_num BINARY_INTEGER;
1032: --

Line 1129: FROM ben_prtn_elig_f epa2

1125: the user. */
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 =

Line 1223: FROM ben_prtn_elig_f epa2

1219: profile that has been specified by the user. */
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 =

Line 1319: FROM ben_prtn_elig_f epa2

1315: eligibility profile that has been specified by the user. */
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

Line 1528: FROM ben_prtn_elig_f epa2

1524: OR p_vrbl_rt_prfl_id IS NULL)
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

Line 1931: l_tabname_set(7) := 'ben_prtn_elig_f';

1927: l_tabname_set(4) := 'ben_opt_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';