[Home] [Help]
123: --
124: l_strg := 'update '||p_table_name||' t set drvbl_fctr_prtn_elig_flag = :1
125:
126: where '||p_col_name|| '= :2 and (
127: exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
128: ben_prtn_elig_prfl_f cep
129: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
130: cep.eligy_prfl_id = eap.eligy_prfl_id) or
131: exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
153: elsif p_event = 'DELETE' then
154: hr_utility.set_location('update event ',10);
155: l_strg := 'update '||p_table_name||' t set drvbl_fctr_prtn_elig_flag = :1
156: where '||p_col_name|| '= :2 and
157: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
158: ben_prtn_elig_prfl_f cep
159: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
160: cep.eligy_prfl_id = eap.eligy_prfl_id) and
161: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
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
261: cep.eligy_prfl_id = eap.eligy_prfl_id) and
262: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
284: If i.pl_id is not null then
285:
286: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'N'
287: where pl_id = i.pl_id and
288: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
289: ben_prtn_elig_prfl_f cep
290: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
291: cep.eligy_prfl_id = eap.eligy_prfl_id) and
292: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
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
321: cep.eligy_prfl_id = eap.eligy_prfl_id) and
322: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
344: If i.ptip_id is not null then
345:
346: update ben_ptip_f set drvbl_fctr_prtn_elig_flag = 'N'
347: where ptip_id = i.ptip_id and
348: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
349: ben_prtn_elig_prfl_f cep
350: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
351: cep.eligy_prfl_id = eap.eligy_prfl_id) and
352: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
374: If i.oipl_id is not null then
375:
376: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'N'
377: where oipl_id = i.oipl_id and
378: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
379: ben_prtn_elig_prfl_f cep
380: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
381: cep.eligy_prfl_id = eap.eligy_prfl_id) and
382: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,