DBA Data[Home] [Help]

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_INST_TRANSACTIONS_V

Line 9484: from CSI_INST_TRANSACTIONS_V

9480: and last_update_date = creation_date;
9481: --
9482: CURSOR TXN_CUR(p_instance_id IN NUMBER) IS
9483: SELECT transaction_id
9484: from CSI_INST_TRANSACTIONS_V
9485: where instance_id = p_instance_id;
9486: --
9487: TYPE NUMLIST is TABLE of NUMBER INDEX BY BINARY_INTEGER;
9488: l_instance_tbl NUMLIST;

Line 10103: from CSI_INST_TRANSACTIONS_V

10099: and msn.lot_number = cii.lot_number);
10100: --
10101: CURSOR TXN_CUR(p_instance_id IN NUMBER) IS
10102: SELECT transaction_id
10103: from CSI_INST_TRANSACTIONS_V
10104: where instance_id = p_instance_id;
10105: --
10106: l_ins_count NUMBER := 0;
10107: l_txn_count NUMBER := 0;