APPS.HRI_OLTP_BEN_PTL_PARAM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49

      SELECT ID
        FROM (SELECT   ID
                  FROM hri_cl_co_pgm_v
                 WHERE SYSDATE BETWEEN start_date AND end_date
              ORDER BY VALUE)
       WHERE ROWNUM < 2;

Line: 95

      SELECT ID
        FROM (SELECT   ID
                  FROM hri_cl_co_pgm_v
                 WHERE SYSDATE BETWEEN start_date AND end_date
              ORDER BY VALUE)
       WHERE ROWNUM < 2;