APPS.JL_JLARPPFF_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: 423

      SELECT
        COUNT(DET.TAX_RATE_ID)
      INTO L_VAT_RATE_QTY
      FROM
        ZX_REP_TRX_DETAIL_T DET
      WHERE DET.TRX_ID = CF_VAT_RATE_QTYFORMULA.TRX_ID
        AND DET.TAX_TYPE_CODE in ( P_VAT_TAX_TYPE , P_NON_TAXABLE_TAX_TYPE );

Line: 592

      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_LOCATIONS_ALL HR
      WHERE HR.LOCATION_ID = P_LOCATION_ID;

Line: 842

      SELECT
        NVL(SUBSTR(ATC.GLOBAL_ATTRIBUTE4
                  ,1
                  ,1)
           ,' ')
      INTO L_DGI_CODE
      FROM
        AP_TAX_CODES ATC,
        AP_INVOICE_DISTRIBUTIONS AID
      WHERE AID.INVOICE_ID = CF_DGI_TRAN_CODEFORMULA.INVOICE_ID
        AND AID.LINE_TYPE_LOOKUP_CODE = 'TAX'
        AND AID.TAX_CODE_ID = ATC.TAX_ID
        AND ATC.TAX_TYPE = P_NON_TAXABLE_TAX_TYPE
        AND ROWNUM = 1;

Line: 868

      SELECT
        count(ATC.TAX_RATE)
      INTO L_COUNT
      FROM
        AP_INVOICE_DISTRIBUTIONS LINES,
        AP_TAX_CODES ATC
      WHERE LINES.TAX_CODE_ID = ATC.TAX_ID
        AND LINES.INVOICE_ID = CF_VAT_COUNTFORMULA.INVOICE_ID
        AND ATC.TAX_TYPE = P_VAT_TAX_TYPE
        AND LINES.LINE_TYPE_LOOKUP_CODE = 'TAX';

Line: 890

      SELECT
        COUNT(ATC.TAX_ID)
      INTO L_VAT_RATE_QTY
      FROM
        AP_TAX_CODES ATC,
        AP_INVOICE_DISTRIBUTIONS AID
      WHERE AID.INVOICE_ID = CF_RATE_QTYFORMULA.INVOICE_ID
        AND ATC.TAX_ID = AID.TAX_CODE_ID
        AND AID.LINE_TYPE_LOOKUP_CODE = 'TAX'
        AND ATC.TAX_TYPE in ( P_VAT_TAX_TYPE , P_NON_TAXABLE_TAX_TYPE );