APPS.AR_CM_APP_LIB_PVT SQL Statements

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

Line: 28

         SELECT customer_trx_id
         INTO   p_customer_trx_id
         FROM   ra_customer_trx
         WHERE   trx_number = p_trx_number;

Line: 132

        SELECT
	   ps.payment_schedule_id
         , ps.invoice_currency_code
         , ct.trx_date
         , ps.gl_date
	 , (ps.amount_due_remaining * -1)
	 , ct.receipt_method_id
        INTO
	  p_cm_ps_id,
          p_cm_currency_code,
          p_trx_date,
          p_cm_gl_date ,
	  p_cm_unapp_amount,
	  p_cm_receipt_method_id
       FROM
           ra_customer_trx  ct
         , ar_payment_schedules  ps
      WHERE
           ps.class                    = 'CM'
       AND ct.customer_trx_id(+)       = ps.customer_trx_id
       AND ct.previous_customer_trx_id is null
       AND ct.customer_trx_id =  p_customer_trx_id
       ;

Line: 313

              SELECT receivable_application_id, gl_date
              INTO   l_rec_appln_id , p_apply_gl_date
              FROM   ar_receivable_applications
              WHERE  customer_trx_id = p_customer_trx_id
                AND  display = 'Y'
		AND applied_payment_schedule_id = -8
                AND  status = 'ACTIVITY';

Line: 339

           SELECT  customer_trx_id, gl_date
           INTO    l_customer_trx_id , p_apply_gl_date
           FROM    ar_receivable_applications
           WHERE   receivable_application_id = p_receivable_application_id
             and   display = 'Y'
             and   applied_payment_schedule_id = -8
             and   status = 'ACTIVITY';

Line: 431

        SELECT customer_trx_id
        INTO   l_customer_trx_id
        FROM   ar_receivable_applications
        WHERE  receivable_application_id = p_receivable_application_id
        AND    applied_payment_schedule_id = -8
        AND    status = 'ACTIVITY'
        and    display = 'Y';

Line: 446

              SELECT receivable_application_id
              INTO   l_rec_appln_id
              FROM   ar_receivable_applications
              WHERE  customer_trx_id = p_customer_trx_id
	      AND    applied_payment_schedule_id = -8
              AND    display = 'Y'
	      AND    status = 'ACTIVITY';

Line: 469

         SELECT gl_date,
                payment_schedule_id,
                (amount_due_remaining * -1)
         INTO   p_cm_gl_date,
                p_cm_ps_id,
		p_cm_unapp_amount
         FROM   ar_payment_schedules
         WHERE  customer_trx_id = l_customer_trx_id;