APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_PRTN_ELIG_F

Line 1013: l_epa ben_prtn_elig_f%ROWTYPE;

1009: l_plip ben_plip_f%ROWTYPE;
1010: l_ptip ben_ptip_f%ROWTYPE;
1011: l_opt ben_opt_f%ROWTYPE;
1012: l_oiplip ben_oiplip_f%ROWTYPE;
1013: l_epa ben_prtn_elig_f%ROWTYPE;
1014: l_plnnip_set ben_pln_cache.g_nipplnpln_cache;
1015: l_inst_count NUMBER;
1016: l_plnrow_num BINARY_INTEGER;
1017: --

Line 1114: FROM ben_prtn_elig_f epa2

1110: the user. */
1111: AND (
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 =

Line 1208: FROM ben_prtn_elig_f epa2

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

Line 1304: FROM ben_prtn_elig_f epa2

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

Line 1513: FROM ben_prtn_elig_f epa2

1509: OR p_vrbl_rt_prfl_id IS NULL)
1510: AND (
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

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

1909: l_tabname_set(4) := 'ben_opt_f';
1910: l_tabname_set(5) := 'ben_oipl_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';