[Home] [Help]
4266: IS
4267:
4268: CURSOR txn_cur(p_instance_id in number) IS
4269: SELECT ct.transaction_type_id
4270: FROM csi_item_instances_h cih,
4271: csi_transactions ct
4272: WHERE cih.instance_id = p_instance_id
4273: AND ct.transaction_id = cih.transaction_id
4274: AND NOT (ct.transaction_type_id = 51 AND ct.source_header_ref_id = p_header_id)