APPS.HRI_OPL_BEN_DIM_REFRESH dependencies on BEN_POPL_RPTG_GRP_F

Line 210: FROM ben_popl_rptg_grp_f rgr, hri_cs_co_pgm_ct pgmd

206:
207: CURSOR c_popl_rptg_grp
208: IS
209: SELECT rgr.popl_rptg_grp_id, rgr.rptg_grp_id, rgr.pgm_id
210: FROM ben_popl_rptg_grp_f rgr, hri_cs_co_pgm_ct pgmd
211: WHERE rgr.pgm_id IS NOT NULL
212: AND rgr.pgm_id = pgmd.pgm_id
213: AND l_effective_date BETWEEN rgr.effective_start_date
214: AND rgr.effective_end_date

Line 592: FROM ben_popl_rptg_grp_F rgr

588: -- Reporting Group Dimension
589: --
590: DELETE FROM HRI_CS_CO_RPGH_PIRG_CT rgrd
591: WHERE NOT EXISTS (SELECT 'x'
592: FROM ben_popl_rptg_grp_F rgr
593: WHERE rgr.rptg_grp_id = rgrd.RPTGTYP_ID
594: AND rgr.pgm_id = rgrd.pgm_id);
595: --
596: output('Removed Deleted Data: ' || to_char(sysdate,'HH24:MI:SS'));

Line 710: FROM ben_popl_rptg_grp_f rgr, hri_cs_co_pgm_ct pgmd

706: --
707: CURSOR c_popl_rptg_grp
708: IS
709: SELECT rgr.popl_rptg_grp_id, rgr.rptg_grp_id, rgr.pgm_id
710: FROM ben_popl_rptg_grp_f rgr, hri_cs_co_pgm_ct pgmd
711: WHERE rgr.pgm_id IS NOT NULL
712: AND rgr.pgm_id = pgmd.pgm_id
713: AND l_effective_date BETWEEN rgr.effective_start_date
714: AND rgr.effective_end_date;