APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_PGM_F

Line 223: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'Y'

219: if p_event = 'CREATE' then
220:
221: For i in c1 loop
222: If i.pgm_id is not null then
223: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'Y'
224: where pgm_id = i.pgm_id;
225: end if;
226:
227: If i.pl_id is not null then

Line 251: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'N'

247: elsif p_event = 'DELETE' then
248: For i in c1 Loop
249: If i.pgm_id is not null then
250:
251: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'N'
252: where pgm_id = i.pgm_id and
253: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
254: ben_prtn_elig_prfl_f cep
255: where epa.pgm_id = i.pgm_id and epa.prtn_elig_id = cep.prtn_elig_id and