APPS.CSI_GENERIC_GRP dependencies on CSI_INSTANCE_STATUSES

Line 732: AND not exists ( SELECT 'X' from csi_instance_statuses cis

728: cii.object_version_number
729: FROM csi_item_instances cii
730: WHERE nvl(cii.active_end_date , sysdate) < sysdate
731: AND cii.instance_status_id <> p_expired_status_id
732: AND not exists ( SELECT 'X' from csi_instance_statuses cis
733: WHERE cis.instance_status_id = cii.instance_status_id
734: AND cis.terminated_flag = 'Y');
735:
736: l_exp_instance_rec csi_datastructures_pub.instance_rec;