APPS.PAY_PYAULLAL_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        CURRENCY_CODE,
        PRECISION
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE in (
        SELECT
          I.ORG_INFORMATION9
        FROM
          HR_ORGANIZATION_INFORMATION I
        WHERE I.ORGANIZATION_ID = P_BUSINESS_GROUP_ID
          AND I.ORG_INFORMATION_CONTEXT = 'Business Group Information' );

Line: 56

      SELECT
        TO_CHAR(EFFECTIVE_DATE
               ,'DD-MON-YYYY') || ' (' || TO_CHAR(PAYROLL_ACTION_ID) || ')' PAYROLL_ACTION_DESC
      FROM
        PAY_PAYROLL_ACTIONS
      WHERE PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID;

Line: 75

      SELECT
        PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F
      WHERE PAYROLL_ID = P_PAYROLL;

Line: 92

      SELECT
        CONCATENATED_SEGMENTS
      FROM
        PAY_COST_ALLOCATION_KEYFLEX
      WHERE COST_ALLOCATION_KEYFLEX_ID = P_COST_ALLOCATION_KEYFLEX_ID;