DBA Data[Home] [Help]

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))