229: where pl_id = i.pl_id;
230: end if;
231:
232: If i.plip_id is not null then
233: update ben_plip_f set drvbl_fctr_prtn_elig_flag = 'Y'
234: where plip_id = i.plip_id;
235: end if;
236:
237: If i.ptip_id is not null then
307: End If;
308: --
309: If i.plip_id is not null then
310:
311: update ben_plip_f set drvbl_fctr_prtn_elig_flag = 'N'
312: where plip_id = i.plip_id and
313: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
314: ben_prtn_elig_prfl_f cep
315: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and