APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_ELIG_PCT_FL_TM_PRTE_F

Line 142: exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

138: exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
139: ben_prtn_elig_prfl_f cep
140: where epa.'||p_col_name||'= :7 and epa.prtn_elig_id = cep.prtn_elig_id and
141: cep.eligy_prfl_id = els.eligy_prfl_id) or
142: exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
143: ben_prtn_elig_prfl_f cep
144: where epa.'||p_col_name||'= :8 and epa.prtn_elig_id = cep.prtn_elig_id and
145: cep.eligy_prfl_id = epf.eligy_prfl_id))';
146: execute immediate l_strg using 'Y',p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id;

Line 172: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

168: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
169: ben_prtn_elig_prfl_f cep
170: where epa.'||p_col_name||'= :7 and epa.prtn_elig_id = cep.prtn_elig_id and
171: cep.eligy_prfl_id = els.eligy_prfl_id) and
172: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
173: ben_prtn_elig_prfl_f cep
174: where epa.'||p_col_name||'= :8 and epa.prtn_elig_id = cep.prtn_elig_id and
175: cep.eligy_prfl_id = epf.eligy_prfl_id)';
176: execute immediate l_strg using 'N',p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id,p_col_id;

Line 273: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

269: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
270: ben_prtn_elig_prfl_f cep
271: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
272: cep.eligy_prfl_id = els.eligy_prfl_id) and
273: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
274: ben_prtn_elig_prfl_f cep
275: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and
276: cep.eligy_prfl_id = epf.eligy_prfl_id);
277: End If;

Line 303: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

299: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
300: ben_prtn_elig_prfl_f cep
301: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
302: cep.eligy_prfl_id = els.eligy_prfl_id) and
303: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
304: ben_prtn_elig_prfl_f cep
305: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
306: cep.eligy_prfl_id = epf.eligy_prfl_id);
307: End If;

Line 333: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

329: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
330: ben_prtn_elig_prfl_f cep
331: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
332: cep.eligy_prfl_id = els.eligy_prfl_id) and
333: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
334: ben_prtn_elig_prfl_f cep
335: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and
336: cep.eligy_prfl_id = epf.eligy_prfl_id);
337: End If;

Line 363: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

359: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
360: ben_prtn_elig_prfl_f cep
361: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
362: cep.eligy_prfl_id = els.eligy_prfl_id) and
363: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
364: ben_prtn_elig_prfl_f cep
365: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
366: cep.eligy_prfl_id = epf.eligy_prfl_id);
367: End If;

Line 393: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,

389: not exists (select null from ben_elig_los_prte_f els, ben_prtn_elig_f epa,
390: ben_prtn_elig_prfl_f cep
391: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
392: cep.eligy_prfl_id = els.eligy_prfl_id) and
393: not exists (select null from ben_elig_pct_fl_tm_prte_f epf, ben_prtn_elig_f epa,
394: ben_prtn_elig_prfl_f cep
395: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
396: cep.eligy_prfl_id = epf.eligy_prfl_id);
397: End If;