DBA Data[Home] [Help]

APPS.ARP_DEDUCTION_COVER dependencies on AR_RECEIVABLES_TRX

Line 385: FROM ar_receivables_trx

381: ELSE
382: BEGIN
383: SELECT receivables_trx_id
384: INTO l_receivables_trx_id
385: FROM ar_receivables_trx
386: WHERE receivables_trx_id = p_receivables_trx_id
387: AND NVL(status,'A') = 'A'
388: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,TRUNC(SYSDATE))
389: AND NVL(end_date_active,trunc(SYSDATE))