APPS.AP_APXFPMDR_XMLP_PKG SQL Statements

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

Line: 13

    SELECT
      P.BASE_CURRENCY_CODE,
      C.PRECISION,
      C.MINIMUM_ACCOUNTABLE_UNIT,
      C.DESCRIPTION
    INTO BASE_CURR,PREC,MIN_AU,DESCR
    FROM
      AP_SYSTEM_PARAMETERS P,
      FND_CURRENCIES_VL C
    WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;

Line: 57

    SELECT
      LY.MEANING,
      LN.MEANING,
      LA.DISPLAYED_FIELD
    INTO NLS_YES,NLS_NO,NLS_ALL
    FROM
      FND_LOOKUPS LY,
      FND_LOOKUPS LN,
      AP_LOOKUP_CODES LA
    WHERE LY.LOOKUP_TYPE = 'YES_NO'
      AND LY.LOOKUP_CODE = 'Y'
      AND LN.LOOKUP_TYPE = 'YES_NO'
      AND LN.LOOKUP_CODE = 'N'
      AND LA.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
      AND LA.LOOKUP_CODE = 'ALL';

Line: 169

    SELECT
      NAME,
      CHART_OF_ACCOUNTS_ID
    INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS GSB,
      AP_SYSTEM_PARAMETERS ASP
    WHERE GSB.SET_OF_BOOKS_ID = ASP.SET_OF_BOOKS_ID;

Line: 192

      SELECT
        CBA.BANK_ACCOUNT_NAME
      INTO L_BANK_ACCOUNT_NAME
      FROM
        CE_BANK_ACCOUNTS CBA,
        CE_BANK_ACCT_USES_ALL CBAU
      WHERE CBA.BANK_ACCOUNT_ID = CBAU.BANK_ACCOUNT_ID
        AND CBAU.BANK_ACCT_USE_ID = P_CE_BANK_ACCT_USE_ID;

Line: 205

      SELECT
        PARTY_NAME
      INTO L_PARTY_NAME
      FROM
        HZ_PARTIES
      WHERE PARTY_ID = P_PARTY_ID;

Line: 216

      SELECT
        VENDOR_SITE_CODE
      INTO L_SUPPLIER_SITE
      FROM
        AP_SUPPLIER_SITES_ALL
      WHERE VENDOR_SITE_ID = P_VENDOR_SITE_ID;