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
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,