APPS.JA_JAINSTR_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 42

      SELECT
        SUM(AMOUNT_APPLIED)
      FROM
        AR_RECEIVABLE_APPLICATIONS_ALL
      WHERE APPLIED_CUSTOMER_TRX_ID = INVOICE_ID
        AND APPLICATION_TYPE = 'CASH'
        AND STATUS in ( 'APP' , 'UNAPP' );

Line: 79

      SELECT
        TRX_NUMBER
      FROM
        JAI_AR_TRXS
      WHERE CUSTOMER_TRX_ID = INVOICE_ID_1;

Line: 85

      SELECT
        DISTINCT
        TRX.*
      FROM
        RA_CUSTOMER_TRX_ALL TRX,
        RA_CUST_TRX_TYPES_ALL TRX_TYPE,
        JAI_AR_TRXS JTRX,
        JAI_AR_TRX_LINES JTRXL,
        JAI_AR_TRX_TAX_LINES JTRXTL,
        JAI_CMN_TAXES_ALL JTC
      WHERE TRX.ORG_ID = ORG_ID1
        AND TRX.COMPLETE_FLAG = 'Y'
        AND TRX.PREVIOUS_CUSTOMER_TRX_ID = INVOICE_ID_1
        AND TRX.CUSTOMER_TRX_ID = JTRX.CUSTOMER_TRX_ID
        AND UPPER(TRX_TYPE.TYPE) = 'CM'
        AND TRX_TYPE.CUST_TRX_TYPE_ID = TRX.CUST_TRX_TYPE_ID
        AND TRX_TYPE.ORG_ID = TRX.ORG_ID
        AND JTRX.CUSTOMER_TRX_ID = JTRXL.CUSTOMER_TRX_ID
        AND JTRXL.CUSTOMER_TRX_LINE_ID = JTRXTL.LINK_TO_CUST_TRX_LINE_ID
        AND JTRXTL.TAX_ID = JTC.TAX_ID
        AND UPPER(JTC.TAX_TYPE) IN ( 'SERVICE' , 'SERVICE_EDUCATION_CESS' , 'SERVICE_SH_EDU_CESS' );

Line: 107

      SELECT
        SUM(NVL(AMOUNT
               ,0))
      FROM
        RA_CUST_TRX_LINE_GL_DIST_ALL
      WHERE CUSTOMER_TRX_ID = INVOICE_ID_1
        AND ACCOUNT_CLASS = 'REC';

Line: 115

      SELECT
        TAXABLE_BASIS SH_CESS_BASIS,
        RECOVERABLE_PTG SH_CESS_REC_PERCENT,
        RECOVERABLE_AMOUNT SH_CESS_REC_AMOUNT,
        RECOVERED_AMOUNT SH_CESS_PAYABLE_AMOUNT
      FROM
        JAI_RGM_TRX_REFS
      WHERE SOURCE = 'AR'
        AND INVOICE_ID = INVOICE_ID_1
        AND TAX_TYPE = 'SERVICE_SH_EDU_CESS';

Line: 194

        FOR CM_tot_amt IN (SELECT
                             SUM(NVL(AMOUNT
                                    ,0)) AMOUNT
                           FROM
                             RA_CUST_TRX_LINE_GL_DIST_ALL
                           WHERE CUSTOMER_TRX_ID = CM_INV.CUSTOMER_TRX_ID
                             AND ACCOUNT_CLASS = 'REC') LOOP
          LN_CM_GROSS_AMT_TMP := CM_TOT_AMT.AMOUNT;

Line: 207

        FOR amt_det IN (SELECT
                          JRTR1.ORGANIZATION_ID ORG_ID1,
                          JRTR1.INVOICE_ID INVOICE_ID,
                          JRTR1.TAXABLE_BASIS SERVICE_BASIS,
                          JRTR1.RECOVERABLE_PTG SERVICE_REC_PERCENT,
                          JRTR1.RECOVERABLE_AMOUNT SERVICE_REC_AMOUNT,
                          JRTR1.RECOVERED_AMOUNT SERVICE_PAYABLE_AMOUNT,
                          JRTR2.TAXABLE_BASIS CESS_BASIS,
                          JRTR2.RECOVERABLE_PTG CESS_REC_PERCENT,
                          JRTR2.RECOVERABLE_AMOUNT CESS_REC_AMOUNT,
                          JRTR2.RECOVERED_AMOUNT CESS_PAYABLE_AMOUNT
                        FROM
                          JAI_RGM_TRX_REFS JRTR1,
                          JAI_RGM_TRX_REFS JRTR2
                        WHERE JRTR1.SOURCE = 'AR'
                          AND JRTR1.INVOICE_ID = jrtr2.invoice_id (+)
                          AND JRTR1.INVOICE_ID = CM_INV.CUSTOMER_TRX_ID
                          AND JRTR1.TAX_TYPE = 'Service'
                          AND JRTR2.TAX_TYPE = 'SERVICE_EDUCATION_CESS') LOOP
          LN_CM_TAXABLE_BASIS := LN_CM_TAXABLE_BASIS + NVL(AMT_DET.SERVICE_BASIS
                                    ,0);

Line: 312

      SELECT
        DESCRIPTION
      FROM
        JA_LOOKUPS
      WHERE LOOKUP_TYPE = 'JAI_SERVICE_TYPE'
        AND LOOKUP_CODE = CP_SERVICE_TYPE_CODE;