APPS.HRI_OLTP_PMV_OPEN_ENRT_STAT dependencies on HRI_CS_TIME_BENRL_PRD_CT

Line 31: FROM hri_cs_time_benrl_prd_ct enp

27: cv_effective_date DATE )
28: IS
29: SELECT asnd_lf_evt_dt
30: FROM (SELECT MAX (asnd_lf_evt_dt) asnd_lf_evt_dt
31: FROM hri_cs_time_benrl_prd_ct enp
32: WHERE pgm_id = cv_pgm_id
33: AND enrt_strt_dt <= cv_effective_date
34: );
35: --

Line 41: FROM hri_cs_time_benrl_prd_ct enp

37: cv_effective_date DATE )
38: IS
39: SELECT asnd_lf_evt_dt
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