APPS.JL_JLCOPWHR_XMLP_PKG SQL Statements

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

Line: 11

    SELECT
      DISTINCT
      ( CHART_OF_ACCOUNTS_ID )
    INTO L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS G,
      AP_SYSTEM_PARAMETERS A
    WHERE G.SET_OF_BOOKS_ID = P_SOB_ID;

Line: 22

    SELECT
      P.BASE_CURRENCY_CODE,
      C.PRECISION
    INTO BASE_CURR,PREC
    FROM
      AP_SYSTEM_PARAMETERS P,
      FND_CURRENCIES_VL C
    WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE
      AND P.SET_OF_BOOKS_ID = P_SOB_ID;

Line: 36

    SELECT
      HR.GLOBAL_ATTRIBUTE8
    INTO P_1
    FROM
      HR_LOCATIONS HR
    WHERE HR.LOCATION_ID = C_LOCATION_ID;

Line: 50

    SELECT
      ROUND(SUM((AID.AMOUNT * ATC2.TAX_RATE) / 100)
           ,P_MIN_PRECISION) VAT_AMOUNT
    INTO V_VAT_AMOUNT
    FROM
      AP_TAX_CODES ATC,
      JL_ZZ_AP_SUP_AWT_CD JZSAC,
      JL_ZZ_AP_INV_DIS_WH JZIDW,
      AP_TAX_CODES ATC2,
      AP_INVOICES AI,
      AP_INVOICE_DISTRIBUTIONS AID
    WHERE AID.ACCOUNTING_DATE BETWEEN P_ACCOUNTING_DATE_FROM
      AND P_ACCOUNTING_DATE_TO
      AND AID.MATCH_STATUS_FLAG = 'A'
      AND AID.LINE_TYPE_LOOKUP_CODE <> 'AWT'
      AND AID.LINE_TYPE_LOOKUP_CODE <> 'TAX'
      AND JZIDW.INVOICE_ID = AID.INVOICE_ID
      AND JZIDW.DISTRIBUTION_LINE_NUMBER = AID.DISTRIBUTION_LINE_NUMBER
      AND JZSAC.SUPP_AWT_CODE_ID = JZIDW.SUPP_AWT_CODE_ID
      AND ATC.TAX_ID = JZSAC.TAX_ID
      AND ATC.GLOBAL_ATTRIBUTE19 is not null
      AND ATC.NAME = P_TAX_NAME
      AND AID.TAX_CODE_ID is not null
      AND ATC2.TAX_ID = AID.TAX_CODE_ID
      AND AI.INVOICE_ID = AID.INVOICE_ID
      AND AI.INVOICE_NUM = DOCUMENT_NUMBER
      AND AI.CANCELLED_DATE is null
      AND ( ( AID.GLOBAL_ATTRIBUTE2 is null
      AND AID.INVOICE_ID = AI.INVOICE_ID
      AND AI.VENDOR_ID = P_VENDOR_ID )
    OR ( AID.GLOBAL_ATTRIBUTE2 = P_VENDOR_NUMBER
      AND AID.INVOICE_ID = AI.INVOICE_ID ) )
      AND exists (
      SELECT
        1
      FROM
        AP_INVOICE_DISTRIBUTIONS AID2
      WHERE AID2.INVOICE_ID = AID.INVOICE_ID
        AND AID2.MATCH_STATUS_FLAG = 'A'
        AND AID2.LINE_TYPE_LOOKUP_CODE = 'AWT'
        AND AID2.TAX_CODE_ID = ATC.TAX_ID
        AND ( ( AID2.GLOBAL_ATTRIBUTE2 is null )
      OR ( AID2.GLOBAL_ATTRIBUTE2 = P_VENDOR_NUMBER ) ) );

Line: 119

    SELECT
      NAME,
      CHART_OF_ACCOUNTS_ID
    INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
    FROM
      GL_SETS_OF_BOOKS G,
      AP_SYSTEM_PARAMETERS_ALL A
    WHERE G.SET_OF_BOOKS_ID = A.SET_OF_BOOKS_ID;

Line: 162

    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: 201

    SELECT
      START_DATE
    INTO X_START_DATE
    FROM
      GL_PERIODS A,
      GL_SETS_OF_BOOKS B
    WHERE B.SET_OF_BOOKS_ID = P_SOB_ID
      AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
      AND UPPER(A.PERIOD_NAME) = UPPER(P_PERIOD_FROM);

Line: 217

    SELECT
      END_DATE
    INTO X_END_DATE
    FROM
      GL_PERIODS A,
      GL_SETS_OF_BOOKS B
    WHERE B.SET_OF_BOOKS_ID = P_SOB_ID
      AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
      AND UPPER(A.PERIOD_NAME) = UPPER(P_PERIOD_TO);

Line: 230

  FUNCTION F_SELECTED_TAXPAYERID RETURN VARCHAR2 IS
    RET_TEXT VARCHAR2(1000) := NULL;

Line: 248

  END F_SELECTED_TAXPAYERID;

Line: 253

    P_SELECTED_TAXPAYERID := F_SELECTED_TAXPAYERID;