APPS.PAY_PYAUSGC_XMLP_PKG SQL Statements

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

Line: 23

    SELECT
      LAST_DAY(P_DATE)
    INTO
      P_END_DATE
    FROM
      DUAL;

Line: 29

    SELECT
      'For' || '  ' || TO_CHAR(P_DATE
             ,'MON-YYYY')
    INTO
      P_MON_YYYY
    FROM
      DUAL;

Line: 49

      SELECT
        ORG_INFORMATION9
      FROM
        HR_ORGANIZATION_INFORMATION
      WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
        AND ORG_INFORMATION9 is not null;

Line: 69

      SELECT
        CURRENCY_CODE
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;

Line: 122

      SELECT
        CONCATENATED_SEGMENTS
      FROM
        PAY_COST_ALLOCATION_KEYFLEX
      WHERE COST_ALLOCATION_KEYFLEX_ID = P_COST_CENTRE;

Line: 148

      SELECT
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_CODE = P_ALL_EXCEPTION
        AND LOOKUP_TYPE = 'AU_SGC_COMPLIANCE'
        AND ENABLED_FLAG = 'Y';