APPS.CSI_GENERIC_GRP dependencies on CSI_ITEM_INSTANCES

Line 512: FROM csi_item_instances

508: l_dummy := NULL;
509: BEGIN
510: SELECT 'x'
511: INTO l_dummy
512: FROM csi_item_instances
513: WHERE instance_id = p_ext_attrib_rec.instance_id;
514: EXCEPTION
515: WHEN NO_DATA_FOUND THEN
516: fnd_message.set_name('CSI', 'CSI_INVALID_INS_PARAMETER');

Line 729: FROM csi_item_instances cii

725: SELECT cii.instance_id,
726: cii.instance_number,
727: cii.active_end_date,
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