APPS.JG_JGZZRDLR_XMLP_PKG SQL Statements

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

Line: 13

	SELECT NVL(PRECISION,2)
        INTO MIN_PRECISION
        FROM FND_CURRENCIES
        WHERE CURRENCY_CODE = CURR_CODE;

Line: 75

      SELECT
        MEANING
      INTO C_RAR_YES_NO
      FROM
        FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
        AND LOOKUP_CODE = P_INCL_RAR;

Line: 422

    SELECT
      LETTER_NAME
    INTO L_DUNNING_NAME
    FROM
      AR_DUNNING_LETTERS
    WHERE DUNNING_LETTER_ID = P_DUNNING_LETTER_ID;

Line: 452

        SELECT
          NVL(SUM(ARA.AMOUNT_APPLIED)
             ,0)
        INTO L_AMOUNT
        FROM
          AR_RECEIVABLE_APPLICATIONS ARA,
          AR_CASH_RECEIPTS RPT,
          AR_CASH_RECEIPT_HISTORY RTPH
        WHERE ARA.APPLIED_CUSTOMER_TRX_ID = TRX_ID
          AND ARA.CASH_RECEIPT_ID = RPT.CASH_RECEIPT_ID
          AND RPT.CASH_RECEIPT_ID = RTPH.CASH_RECEIPT_ID
          AND RTPH.CURRENT_RECORD_FLAG = 'Y'
          AND ( ( RTPH.TRX_DATE > '''' || P_AS_OF_DATE1 || ''''
          AND RTPH.STATUS = 'CLEARED' )
        OR RTPH.STATUS <> 'CLEARED'
        OR ( ARA.APPLY_DATE > '''' || P_AS_OF_DATE1 || ''''
          AND RTPH.STATUS = 'CLEARED' ) );