APPS.XTR_XTRHOAPR_XMLP_PKG SQL Statements

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

Line: 11

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'XTR_HEDGE_SOURCES'
        AND LOOKUP_CODE = P_SOURCE;

Line: 18

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
        AND LOOKUP_CODE = P_MISC;

Line: 25

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_YES_NO;

Line: 32

      SELECT
        FULL_NAME
      FROM
        XTR_PARTY_INFO_V
      WHERE PARTY_CODE = P_COMPANY_CODE;

Line: 38

      SELECT
        MEANING
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'XTR_NUM_FACTOR'
        AND LOOKUP_CODE = P_FACTOR;

Line: 45

      SELECT
        CP.USER_CONCURRENT_PROGRAM_NAME
      FROM
        FND_CONCURRENT_PROGRAMS_VL CP,
        FND_CONCURRENT_REQUESTS CR
      WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
        AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
        AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;

Line: 248

      SELECT
        ITEM_NAME,
        TEXT LANG_NAME
      FROM
        XTR_SYS_LANGUAGES_VL
      WHERE MODULE_NAME = 'XTRHOAPR';

Line: 368

      DELETE FROM XTR_HEDGE_CRITERIA
       WHERE CRITERIA_SET = P_CRITERIA_SET_V
         AND CRITERIA_SET_OWNER = P_CRITERIA_SET_OWNER;

Line: 382

      SELECT
        NAME
      FROM
        HR_OPERATING_UNITS OU
      WHERE ORGANIZATION_ID = P_VALUE;

Line: 388

      SELECT
        VENDOR_NAME
      FROM
        PO_VENDORS
      WHERE VENDOR_ID = P_VALUE;

Line: 394

      SELECT
        DISPLAYED_FIELD
      FROM
        AP_LOOKUP_CODES
      WHERE LOOKUP_TYPE = 'INVOICE TYPE'
        AND LOOKUP_CODE = P_VALUE;

Line: 401

      SELECT
        DISPLAYED_FIELD
      FROM
        AP_LOOKUP_CODES
      WHERE LOOKUP_TYPE = 'SOURCE'
        AND LOOKUP_CODE = P_VALUE;