[Home] [Help]
118: --
119: l_strg := 'update '||p_table_name||' t set drvbl_fctr_prtn_elig_flag = :1
120:
121: where '||p_col_name|| '= :2 and (
122: exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
123: ben_prtn_elig_prfl_f cep
124: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
125: cep.eligy_prfl_id = eap.eligy_prfl_id) or
126: exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
148: elsif p_event = 'DELETE' then
149: hr_utility.set_location('update event ',10);
150: l_strg := 'update '||p_table_name||' t set drvbl_fctr_prtn_elig_flag = :1
151: where '||p_col_name|| '= :2 and
152: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
153: ben_prtn_elig_prfl_f cep
154: where epa.'||p_col_name||' = :3 and epa.prtn_elig_id = cep.prtn_elig_id and
155: cep.eligy_prfl_id = eap.eligy_prfl_id) and
156: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
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
256: cep.eligy_prfl_id = eap.eligy_prfl_id) and
257: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
279: If i.pl_id is not null then
280:
281: update ben_pl_f set drvbl_fctr_prtn_elig_flag = 'N'
282: where pl_id = i.pl_id and
283: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
284: ben_prtn_elig_prfl_f cep
285: where epa.pl_id = i.pl_id and epa.prtn_elig_id = cep.prtn_elig_id and
286: cep.eligy_prfl_id = eap.eligy_prfl_id) and
287: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
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
316: cep.eligy_prfl_id = eap.eligy_prfl_id) and
317: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
339: If i.ptip_id is not null then
340:
341: update ben_ptip_f set drvbl_fctr_prtn_elig_flag = 'N'
342: where ptip_id = i.ptip_id and
343: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
344: ben_prtn_elig_prfl_f cep
345: where epa.ptip_id = i.ptip_id and epa.prtn_elig_id = cep.prtn_elig_id and
346: cep.eligy_prfl_id = eap.eligy_prfl_id) and
347: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,
369: If i.oipl_id is not null then
370:
371: update ben_oipl_f set drvbl_fctr_prtn_elig_flag = 'N'
372: where oipl_id = i.oipl_id and
373: not exists (select null from ben_elig_age_prte_f eap, ben_prtn_elig_f epa,
374: ben_prtn_elig_prfl_f cep
375: where epa.oipl_id = i.oipl_id and epa.prtn_elig_id = cep.prtn_elig_id and
376: cep.eligy_prfl_id = eap.eligy_prfl_id) and
377: not exists (select null from ben_elig_cmbn_age_los_prte_f ecp, ben_prtn_elig_f epa,