DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_INST_TRANSACTIONS_V

Line 3722: FROM csi_inst_transactions_v

3718: ELSIF p_end_date < sysdate THEN -- srramakr
3719: BEGIN
3720: SELECT MAX(source_transaction_date)
3721: INTO l_txn_date
3722: FROM csi_inst_transactions_v
3723: WHERE instance_id=p_instance_id
3724: AND source_transaction_date>p_end_date;
3725: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));
3726: csi_gen_utility_pvt.put_line('value of MAX(transaction_date) in ITEM_VLD_PVT:'||to_char(l_txn_date, 'DD-MON-YYYY HH24:MI:SS'));