APPS.HRI_OLTP_BEN_PTL_PARAM dependencies on HRI_CL_CO_PGM_V
Line 51: FROM hri_cl_co_pgm_v
47: CURSOR c_pgm
48: IS
49: SELECT ID
50: FROM (SELECT ID 51: FROM hri_cl_co_pgm_v 52: WHERE SYSDATE BETWEEN start_date AND end_date
53: ORDER BY VALUE)
54: WHERE ROWNUM < 2;
55: --
Line 97: FROM hri_cl_co_pgm_v
93: CURSOR c_pgm
94: IS
95: SELECT ID
96: FROM (SELECT ID 97: FROM hri_cl_co_pgm_v 98: WHERE SYSDATE BETWEEN start_date AND end_date
99: ORDER BY VALUE)
100: WHERE ROWNUM < 2;
101: --