APPS.HRI_OLTP_PMV_OPEN_ENRT_STAT dependencies on HRI_CS_CO_RPGH_PIRG_CT

Line 44: FROM hri_cs_co_rpgh_pirg_ct

40: FROM (SELECT MAX (asnd_lf_evt_dt) asnd_lf_evt_dt
41: FROM hri_cs_time_benrl_prd_ct enp
42: WHERE enrt_strt_dt <= cv_effective_date
43: AND pgm_id IN (SELECT pgm_id
44: FROM hri_cs_co_rpgh_pirg_ct
45: WHERE rptgtyp_id = cv_rptgrp_id
46: )
47: );
48: --