DBA Data[Home] [Help]

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: --