293: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
294: and a.prtn_elig_id = b.prtn_elig_id
295: and a.ptip_id = c.ptip_id);
296: --
297: --updates elig_apls_flag to 'Y' in ben_pl_f table.
298: update ben_pl_f c
299: set c.elig_apls_flag = 'Y'
300: where exists
301: (select a.pl_id
294: and a.prtn_elig_id = b.prtn_elig_id
295: and a.ptip_id = c.ptip_id);
296: --
297: --updates elig_apls_flag to 'Y' in ben_pl_f table.
298: update ben_pl_f c
299: set c.elig_apls_flag = 'Y'
300: where exists
301: (select a.pl_id
302: from ben_prtn_elig_f a,
812: and c.ptip_id = l_c1.ptip_id;
813: --
814: elsif l_c1.pl_id is not null then
815: --
816: --updates elig_apls_flag to 'N' in ben_pl_f table
817: --only when no record found in profile and rule tables.
818: update ben_pl_f c
819: set c.elig_apls_flag = 'N'
820: where not exists
814: elsif l_c1.pl_id is not null then
815: --
816: --updates elig_apls_flag to 'N' in ben_pl_f table
817: --only when no record found in profile and rule tables.
818: update ben_pl_f c
819: set c.elig_apls_flag = 'N'
820: where not exists
821: (select a.pl_id
822: from ben_prtn_elig_f a,