APPS.BEN_DERIVABLE_FACTOR dependencies on BEN_PGM_F

Line 228: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'Y'

224: if p_event = 'CREATE' then
225:
226: For i in c1 loop
227: If i.pgm_id is not null then
228: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'Y'
229: where pgm_id = i.pgm_id;
230: end if;
231:
232: If i.pl_id is not null then

Line 256: update ben_pgm_f set drvbl_fctr_prtn_elig_flag = 'N'

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