APPS.ARP_TRX_SUM_UTIL SQL Statements

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

Line: 47

       SELECT nvl(sum(lgd.amount), 0)
       INTO   l_sum_value
       FROM   ra_customer_trx ct,
              ra_cust_trx_line_gl_dist lgd
       WHERE  ct.customer_trx_id  = lgd.customer_trx_id
       AND    ct.batch_id         = p_batch_id
       AND    lgd.account_class   = 'REC'
       AND    lgd.latest_rec_flag = 'Y';

Line: 56

       SELECT count(*)
       INTO   l_sum_value
       FROM   ra_customer_trx ct
       WHERE  ct.batch_id = p_batch_id;

Line: 75

 |    update values  without having to requery the trx batches form.         |
 |                                                                           |
 |    implemented as a fix for Enhancement #561984.                          |
 |                                                                           |
 | SCOPE - PUBLIC                                                            |
 |                                                                           |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED                                   |
 |    arp_util.debug                                                         |
 |                                                                           |
 | ARGUMENTS  : IN:                                                          |
 |                    p_batch_id                                             |
 |              OUT:                                                         |
 |                    l_actual_count                                         |
 |                    l_actual_amount                                        |
 | NOTES                                                                     |
 |                                                                           |
 |                                                                           |
 | MODIFICATION HISTORY                                                      |
 |     08-OCT-95  Debbie Jancis         Created                              |
 |                                                                           |
 +===========================================================================*/
PROCEDURE get_batch_summary_all ( p_batch_id IN number,
                                  l_actual_count OUT NOCOPY number,
                                  l_actual_amount OUT NOCOPY number )

IS
BEGIN

  l_actual_amount := null;

Line: 107

       SELECT nvl(sum(lgd.amount), 0)
       INTO   l_actual_amount
       FROM   ra_customer_trx ct,
              ra_cust_trx_line_gl_dist lgd
       WHERE  ct.customer_trx_id  = lgd.customer_trx_id
       AND    ct.batch_id         = p_batch_id
       AND    lgd.account_class   = 'REC'
       AND    lgd.latest_rec_flag = 'Y';

Line: 117

       SELECT count(*)
       INTO   l_actual_count
       FROM   ra_customer_trx ct
       WHERE  ct.batch_id = p_batch_id;