APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_PGM_F

Line 113: FROM ben_pgm_f pgm

109: l_login_id NUMBER := fnd_global.login_id;
110: --
111: CURSOR c_pgm IS
112: SELECT pgm.pgm_id pgm_id
113: FROM ben_pgm_f pgm
114: WHERE l_effective_date BETWEEN pgm.effective_start_date
115: AND pgm.effective_end_date
116: AND pgm.pgm_typ_cd IN ('CORE', 'FLEX', 'FPC', 'OTHER')
117: AND EXISTS (

Line 533: FROM ben_pgm_f pgm

529: -- Program Dimension
530: --
531: DELETE FROM HRI_CS_CO_PGM_CT pgmd
532: WHERE NOT EXISTS (SELECT 'x'
533: FROM ben_pgm_f pgm
534: WHERE pgm.pgm_id = pgmd.pgm_id);
535: --
536: -- Plan Type In Program Dimension
537: --

Line 626: FROM ben_pgm_f pgm

622: l_login_id NUMBER := fnd_global.login_id;
623: --
624: CURSOR c_pgm IS
625: SELECT pgm.pgm_id PGM_ID
626: FROM ben_pgm_f pgm
627: WHERE l_effective_date BETWEEN pgm.effective_start_date
628: AND pgm.effective_end_date
629: AND pgm.pgm_typ_cd in ('CORE', 'FLEX', 'FPC', 'OTHER')
630: AND EXISTS (