DBA Data[Home] [Help]

APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_PLIP_F

Line 238: update ben_plip_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
238: update ben_plip_f set drvbl_fctr_prtn_elig_flag = 'Y'
239: where plip_id = i.plip_id;
240: end if;
241:
242: If i.ptip_id is not null then

Line 316: update ben_plip_f set drvbl_fctr_prtn_elig_flag = 'N'

312: End If;
313: --
314: If i.plip_id is not null then
315:
316: update ben_plip_f set drvbl_fctr_prtn_elig_flag = 'N'
317: where plip_id = i.plip_id and
318: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
319: ben_prtn_elig_prfl_f cep
320: where epa.plip_id = i.plip_id and epa.prtn_elig_id = cep.prtn_elig_id and