APPS.AR_CM_APP_VAL_PVT SQL Statements

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

Line: 92

    SELECT amount_applied,
           amount_applied_from INTO l_amount_applied,l_amount_applied_from
    FROM  ar_receivable_applications
    WHERE receivable_application_id = p_receivable_application_id;

Line: 181

       SELECT count(*)
       INTO   l_valid
       FROM   AR_RECEIVABLE_APPLICATIONS ra
       WHERE  ra.receivable_application_id = p_receivable_application_id
         and  ra.display = 'Y'
         and  ra.status = p_application_type
         and  ra.application_type = 'CM';

Line: 228

 select type
 from   ar_receivables_trx rt
 where  receivables_trx_id = p_receivables_trx_id;

Line: 262

          SELECT sum(amount_applied)
          INTO l_existing_cmref_amount
  	  FROM ar_receivable_applications
  	  WHERE applied_payment_schedule_id = -8
          AND   status = 'ACTIVITY'
          AND   NVL(confirmed_flag,'Y') = 'Y'
          AND   customer_trx_id = p_customer_trx_id;

Line: 279

          SELECT NVL(amount_from,0),
                 NVL(amount_to,0)
          INTO   l_amount_from,
                 l_amount_to
          FROM   ar_approval_user_limits
          where  currency_code = p_currency_code
          and    user_id = l_user_id
          and    document_type ='CMREF';

Line: 460

    SELECT ct.receipt_method_id,
	   ct.customer_bank_account_id,
	   ct.previous_customer_trx_id,
	   ct.complete_flag,
	   rc.remit_flag,
	   rma.remittance_ccid
    FROM   ra_customer_trx ct,
           ar_receipt_methods rm,
	   ar_receipt_classes rc,
           ar_receipt_method_accounts rma
    WHERE  ct.customer_trx_id = p_customer_trx_id
    AND    ct.receipt_method_id = rm.receipt_method_id(+)
    AND    rm.receipt_class_id = rc.receipt_class_id(+)
    AND    rm.receipt_method_id = rma.receipt_method_id(+)
    AND    ROWNUM = 1;

Line: 477

    SELECT SUM(amount_due_original), SUM(amount_due_remaining)
    FROM   ar_payment_schedules
    WHERE  customer_trx_id = p_customer_trx_id;