APPS.JL_JLARTSFF_XMLP_PKG SQL Statements

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

Line: 15

    SELECT
      FCURR.CURRENCY_CODE,
      FCURR.PRECISION,
      FCURR.MINIMUM_ACCOUNTABLE_UNIT,
      FCURR.DESCRIPTION,
      GSBKS.NAME
    INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
    FROM
      AR_SYSTEM_PARAMETERS ASP,
      FND_CURRENCIES_VL FCURR,
      GL_SETS_OF_BOOKS GSBKS
    WHERE ASP.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
      AND GSBKS.CURRENCY_CODE = FCURR.CURRENCY_CODE;

Line: 63

      SELECT
        TAX_CATEGORY_ID
      INTO L_VAT_ID
      FROM
        JL_ZZ_AR_TX_CATEGRY
      WHERE TAX_CATEGORY = P_VAT
        AND ROWNUM = 1;

Line: 77

      SELECT
        TAX_CATEGORY_ID
      INTO L_VATPERC_ID
      FROM
        JL_ZZ_AR_TX_CATEGRY
      WHERE TAX_CATEGORY = P_VATPERC
        AND ROWNUM = 1;

Line: 91

      SELECT
        TAX_CATEGORY_ID
      INTO L_VATADDL_ID
      FROM
        JL_ZZ_AR_TX_CATEGRY
      WHERE TAX_CATEGORY = P_VATADDL
        AND ROWNUM = 1;

Line: 105

      SELECT
        TAX_CATEGORY_ID
      INTO L_EXC_ID
      FROM
        JL_ZZ_AR_TX_CATEGRY
      WHERE TAX_CATEGORY = P_EXCISE
        AND ROWNUM = 1;

Line: 119

      SELECT
        TAX_CATEGORY_ID
      INTO L_VATNOT_ID
      FROM
        JL_ZZ_AR_TX_CATEGRY
      WHERE TAX_CATEGORY = P_VATNOT
        AND ROWNUM = 1;

Line: 133

      SELECT
        TAX_CATEGORY_ID
      INTO L_NON_TAX_ID
      FROM
        JL_ZZ_AR_TX_CATEGRY
      WHERE TAX_CATEGORY = P_VAT_NON_TAXABLE
        AND ROWNUM = 1;

Line: 147

      SELECT
        RPAD(DECODE(HR.GLOBAL_ATTRIBUTE11
                   ,NULL
                   ,'           '
                   ,SUBSTR(HR.GLOBAL_ATTRIBUTE11
                         ,1
                         ,10) || SUBSTR(HR.GLOBAL_ATTRIBUTE12
                         ,1
                         ,1))
            ,11
            ,' ')
      INTO L_TAX_ID
      FROM
        HR_ORGANIZATION_UNITS HRU,
        HR_LOCATIONS_ALL HR
      WHERE HRU.ORGANIZATION_ID = L_ORG_ID
        AND HRU.LOCATION_ID = HR.LOCATION_ID;

Line: 169

    SELECT
      TAXPAYER_ID
    INTO L_TAX_ID
    FROM
      ZX_REP_CONTEXT_T
    WHERE REQUEST_ID = P_CONC_REQUEST_ID;

Line: 191

        SELECT
          TAXPAYER_ID
        INTO L_TAX_ID
        FROM
          ZX_REP_CONTEXT_T
        WHERE REQUEST_ID = P_CONC_REQUEST_ID;

Line: 713

    SELECT
      count(TAX_RATE)
    INTO L_VAT_COUNT
    FROM
      ZX_REP_TRX_DETAIL_T
    WHERE REQUEST_ID = P_CONC_REQUEST_ID
      AND TRX_ID = CUSTOMER_TRX_ID
      AND TAX = P_VAT;