APPS.ARP_DEDUCTION_COVER dependencies on AR_RECEIVABLES_TRX
Line 368: FROM ar_receivables_trx
364: ELSE
365: BEGIN
366: SELECT receivables_trx_id
367: INTO l_receivables_trx_id 368: FROM ar_receivables_trx 369: WHERE receivables_trx_id = p_receivables_trx_id
370: AND NVL(status,'A') = 'A'
371: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,TRUNC(SYSDATE))
372: AND NVL(end_date_active,trunc(SYSDATE))