DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_LOOKUPS

Line 1718: FROM ar_lookups

1714: BEGIN
1715:
1716: SELECT 'reason code is ok'
1717: INTO l_temp
1718: FROM ar_lookups
1719: WHERE lookup_type = 'CREDIT_MEMO_REASON'
1720: AND lookup_code = p_reason_code
1721: AND p_trx_date
1722: BETWEEN NVL( start_date_active, p_trx_date )

Line 1764: FROM ar_lookups

1760: BEGIN
1761:
1762: SELECT 'status code is ok'
1763: INTO l_temp
1764: FROM ar_lookups
1765: WHERE lookup_type = 'INVOICE_TRX_STATUS'
1766: AND lookup_code = p_status_trx
1767: AND p_trx_date
1768: BETWEEN NVL( start_date_active, p_trx_date )