APPS.HXT_HXT970A_XMLP_PKG SQL Statements

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

Line: 8

    SELECT
      PAYROLL_NAME || '   ' || TO_CHAR(PTP.START_DATE
             ,'YYYY/MM/DD') || '  -  ' || TO_CHAR(PTP.END_DATE
             ,'YYYY/MM/DD')
    INTO
      PAYROLL
    FROM
      PER_TIME_PERIODS PTP,
      PAY_PAYROLLS_F PAY
    WHERE PTP.TIME_PERIOD_ID = P_TIME_PERIOD_ID
      AND ( sysdate between PAY.EFFECTIVE_START_DATE
      AND PAY.EFFECTIVE_END_DATE )
      AND ( PTP.PAYROLL_ID = PAY.PAYROLL_ID );

Line: 35

      SELECT
        ERRS.ERROR_MSG
      FROM
        HXT_ERRORS_X ERRS
      WHERE ERRS.TIM_ID = TIMECARD_ID;

Line: 62

      SELECT
        ERRS.ERROR_MSG
      FROM
        HXT_ERRORS_X ERRS
      WHERE ERRS.TIM_ID = TIMECARD_ID2;