APPS.PAY_PAYRPVPR_XMLP_PKG SQL Statements

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

Line: 23

      SELECT
        'x'
      FROM
        PAY_ACTION_PARAMETERS
      WHERE PARAMETER_NAME = 'TRACE'
        AND PARAMETER_VALUE = 'Y';

Line: 41

    SELECT
      sysdate
    INTO
      C_SESSION_DATE
    FROM
      SYS.DUAL;

Line: 47

    SELECT
      LEGISLATION_CODE
    INTO
      P_UK_US
    FROM
      PER_BUSINESS_GROUPS
    WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;

Line: 77

      SELECT
        PCS.CONSOLIDATION_SET_NAME
      INTO
        C_CONSOLIDATION_SET_NAME
      FROM
        PAY_CONSOLIDATION_SETS PCS
      WHERE PCS.CONSOLIDATION_SET_ID = P_CONSOLIDATION_SET_ID;

Line: 90

      SELECT
        NAME
      INTO
        C_GRE_NAME
      FROM
        HR_TAX_UNITS_V
      WHERE TAX_UNIT_ID = P_TAX_UNIT_ID;