APPS.AP_PURGE_PKG dependencies on RCV_TRANSACTIONS

Line 1129: from ap_invoice_distributions aid, rcv_transactions rcv

1125:
1126: DELETE FROM ap_purge_invoice_list PL
1127: WHERE EXISTS (
1128: select 'matched'
1129: from ap_invoice_distributions aid, rcv_transactions rcv
1130: where aid.invoice_id = PL.invoice_id
1131: and aid.rcv_transaction_id = rcv.transaction_id
1132: and rcv.last_update_date > g_activity_date);
1133:

Line 1911: from rcv_transactions_interface rti

1907: or exists (select null
1908: from rcv_headers_interface rhi
1909: where rhi.vendor_id = pvl.vendor_id)
1910: or exists (select null
1911: from rcv_transactions_interface rti
1912: where rti.vendor_id = pvl.vendor_id);
1913:
1914:
1915: end if;

Line 3236: , rcv_transactions rcv

3232: SET PL.double_check_flag = 'N'
3233: WHERE EXISTS (
3234: SELECT 'matched'
3235: FROM ap_invoice_distributions aid
3236: , rcv_transactions rcv
3237: WHERE aid.invoice_id = PL.invoice_id
3238: and aid.rcv_transaction_id = rcv.transaction_id
3239: --Bug 1579474
3240: and rcv.last_update_date > g_activity_date

Line 4062: from rcv_transactions_interface rti

4058: from rcv_headers_interface rhi
4059: where rhi.vendor_id = pvl.vendor_id)
4060: or
4061: exists (select null
4062: from rcv_transactions_interface rti
4063: where rti.vendor_id = pvl.vendor_id));
4064: end if;
4065:
4066: if (g_chv_status = 'Y') then