DBA Data[Home] [Help]

APPS.PO_STORE_TIMECARD_PKG_GRP dependencies on RCV_TRANSACTIONS

Line 408: not exists (select interface_transaction_id from rcv_transactions

404:
405: --First cleanup all the failed transactions from the po_retrieved_timecards.
406: delete /*+ PO_RETRIEVED_TIMECARDS_N6 */po_retrieved_timecards prt
407: where action_flag in ('I', 'U', 'D') and
408: not exists (select interface_transaction_id from rcv_transactions
409: where interface_transaction_id = prt.interface_transaction_id);
410:
411: --now we will reconcile the succsful transactions.
412: open reconcile_csr;