DBA Data[Home] [Help]

APPS.CSI_ML_UPDATE_PVT dependencies on CSI_INSTANCE_INTERFACE

Line 31: FROM csi_instance_interface cii

27: CURSOR inst_intf_cur (p_txn_id IN VARCHAR2,
28: p_source_name IN VARCHAR2)
29: IS
30: SELECT cii.*
31: FROM csi_instance_interface cii
32: WHERE cii.transaction_identifier = p_txn_id
33: AND cii.source_system_name = p_source_name
34: AND cii.instance_id IS NOT NULL --Added for open
35: AND cii.process_status='R'; -- added for bug 3260033

Line 620: -- in csi_instance_interface is under discussion

616: inst_intf_rec.category_id
617: ),
618: l_miss_char, -- INSTANCE_USAGE_CODE
619: -- Commenting the code as existence of instance_usage_code
620: -- in csi_instance_interface is under discussion
621: /*
622: DECODE (
623: inst_intf_rec.instance_usage_code,
624: NULL, l_miss_char,