244: where ptip_id = i.ptip_id;
245: end if;
246:
247: If i.oipl_id is not null then
248: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'Y'
249: where oipl_id = i.oipl_id;
250: end if;
251: End Loop;
252: elsif p_event = 'DELETE' then
372: End If;
373: --
374: If i.oipl_id is not null then
375:
376: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'N'
377: where oipl_id = i.oipl_id and
378: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
379: ben_prtn_elig_prfl_f cep
380: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and