DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on AR_LOOKUPS

Line 1721: FROM ar_lookups

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

Line 1767: FROM ar_lookups

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