APPS.PAY_PAYGBPAY_XMLP_PKG SQL Statements

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

Line: 20

      SELECT
        LEGISLATION_CODE
      INTO P_LEGISLATION_CODE
      FROM
        PER_BUSINESS_GROUPS
      WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;

Line: 26

      SELECT
        DISTINCT
        PAYROLL_NAME
      INTO CP_PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F
      WHERE PAYROLL_ID = P_PAYROLL_ID;

Line: 34

        SELECT
          CONSOLIDATION_SET_NAME
        INTO CP_CONSOLIDATION_SET_NAME
        FROM
          PAY_CONSOLIDATION_SETS
        WHERE CONSOLIDATION_SET_ID = P_CONSOLIDATION_SET_ID;