APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_PL_F

Line 228: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'Y'

224: where pgm_id = i.pgm_id;
225: end if;
226:
227: If i.pl_id is not null then
228: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'Y'
229: where pl_id = i.pl_id;
230: end if;
231:
232: If i.plip_id is not null then

Line 281: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'N'

277: End If;
278: --
279: If i.pl_id is not null then
280:
281: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'N'
282: where pl_id = i.pl_id and
283: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
284: ben_prtn_elig_prfl_f cep
285: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and