DBA Data[Home] [Help]

APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_PLIP_F

Line 233: update ben_plip_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
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

Line 311: update ben_plip_f set drvbl_fctr_prtn_elig_flag = 'N'

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