DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on RCV_TRANSACTIONS

Line 1522: (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS aid, RCV_TRANSACTIONS rt

1518: SELECT 'Y'
1519: INTO l_lcm_used
1520: FROM DUAL
1521: WHERE EXISTS
1522: (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS aid, RCV_TRANSACTIONS rt
1523: WHERE aid.invoice_id = l_invoice_id
1524: AND aid.rcv_transaction_id = rt.transaction_id
1525: AND rt.lcm_shipment_line_id IS NOT NULL
1526: AND aid.match_status_flag = 'S');