APPS.BEN_ELIGIBILITY_RULE_API dependencies on BEN_PLIP_F

Line 275: --updates elig_apls_flag to 'Y' in ben_plip_f table.

271: where b.prtn_eligy_rl_id = l_prtn_eligy_rl_id
272: and a.prtn_elig_id = b.prtn_elig_id
273: and a.pgm_id = c.pgm_id);
274: --
275: --updates elig_apls_flag to 'Y' in ben_plip_f table.
276: update ben_plip_f c
277: set c.elig_apls_flag = 'Y'
278: where exists
279: (select a.plip_id

Line 276: update ben_plip_f c

272: and a.prtn_elig_id = b.prtn_elig_id
273: and a.pgm_id = c.pgm_id);
274: --
275: --updates elig_apls_flag to 'Y' in ben_plip_f table.
276: update ben_plip_f c
277: set c.elig_apls_flag = 'Y'
278: where exists
279: (select a.plip_id
280: from ben_prtn_elig_f a,

Line 776: --updates elig_apls_flag to 'N' in ben_plip_f table

772: and c.pgm_id = l_c1.pgm_id;
773: --
774: elsif l_c1.plip_id is not null then
775: --
776: --updates elig_apls_flag to 'N' in ben_plip_f table
777: --only when no record found in profile and rule tables.
778: update ben_plip_f c
779: set c.elig_apls_flag = 'N'
780: where not exists

Line 778: update ben_plip_f c

774: elsif l_c1.plip_id is not null then
775: --
776: --updates elig_apls_flag to 'N' in ben_plip_f table
777: --only when no record found in profile and rule tables.
778: update ben_plip_f c
779: set c.elig_apls_flag = 'N'
780: where not exists
781: (select a.plip_id
782: from ben_prtn_elig_f a,