APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_OIPL_F

Line 243: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'Y'

239: where ptip_id = i.ptip_id;
240: end if;
241:
242: If i.oipl_id is not null then
243: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'Y'
244: where oipl_id = i.oipl_id;
245: end if;
246: End Loop;
247: elsif p_event = 'DELETE' then

Line 371: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'N'

367: End If;
368: --
369: If i.oipl_id is not null then
370:
371: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'N'
372: where oipl_id = i.oipl_id and
373: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
374: ben_prtn_elig_prfl_f cep
375: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and