DBA Data[Home] [Help]

APPS.PO_STORE_TIMECARD_PKG_GRP dependencies on RCV_TRANSACTIONS

Line 406: not exists (select interface_transaction_id from rcv_transactions

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