DBA Data[Home] [Help]

APPS.BEN_ELIGIBILITY_RULE_API dependencies on BEN_PGM_F

Line 264: --updates elig_apls_flag to 'Y' in ben_pgm_f table.

260: --
261: end;
262: --
263: --update statements
264: --updates elig_apls_flag to 'Y' in ben_pgm_f table.
265: update ben_pgm_f c
266: set c.elig_apls_flag = 'Y'
267: where exists
268: (select a.pgm_id

Line 265: update ben_pgm_f c

261: end;
262: --
263: --update statements
264: --updates elig_apls_flag to 'Y' in ben_pgm_f table.
265: update ben_pgm_f c
266: set c.elig_apls_flag = 'Y'
267: where exists
268: (select a.pgm_id
269: from ben_prtn_elig_f a,

Line 754: --updates elig_apls_flag to 'N' in ben_pgm_f table

750: --
751: end;
752: --
753: --
754: --updates elig_apls_flag to 'N' in ben_pgm_f table
755: --only when no record found in profile and rule tables.
756: if l_c1.pgm_id is not null then
757: --
758: update ben_pgm_f c

Line 758: update ben_pgm_f c

754: --updates elig_apls_flag to 'N' in ben_pgm_f table
755: --only when no record found in profile and rule tables.
756: if l_c1.pgm_id is not null then
757: --
758: update ben_pgm_f c
759: set c.elig_apls_flag = 'N'
760: where not exists
761: (select a.pgm_id
762: from ben_prtn_elig_f a,