DBA Data[Home] [Help]

APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_PL_F

Line 233: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'Y'

229: where pgm_id = i.pgm_id;
230: end if;
231:
232: If i.pl_id is not null then
233: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'Y'
234: where pl_id = i.pl_id;
235: end if;
236:
237: If i.plip_id is not null then

Line 286: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'N'

282: End If;
283: --
284: If i.pl_id is not null then
285:
286: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'N'
287: where pl_id = i.pl_id and
288: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
289: ben_prtn_elig_prfl_f cep
290: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and