APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_II_RELATIONSHIPS

Line 6891: FROM csi_ii_relationships

6887: /*
6888: SELECT 'x' INTO l_exists
6889: FROM dual
6890: WHERE EXISTS (SELECT 'x'
6891: FROM csi_ii_relationships
6892: WHERE object_id = p_instance_rec.instance_id
6893: AND relationship_type_code = 'COMPONENT-OF'
6894: AND NVL (active_end_date,(sysdate+1)) > sysdate);
6895: */

Line 6898: FROM csi_ii_relationships

6894: AND NVL (active_end_date,(sysdate+1)) > sysdate);
6895: */
6896: SELECT 'x'
6897: INTO l_exists
6898: FROM csi_ii_relationships
6899: WHERE object_id = p_instance_rec.instance_id
6900: AND relationship_type_code = 'COMPONENT-OF'
6901: AND NVL (active_end_date,(sysdate+1)) > sysdate
6902: AND ROWNUM=1;