APPS.AHL_OSP_RCV_PVT dependencies on CSI_II_RELATIONSHIPS

Line 2836: from csi_ii_relationships

2832: WHERE instance_id = p_instance_id
2833: AND nvl(csi.active_end_date, sysdate + 1) > sysdate
2834: AND NOT EXISTS
2835: (select subject_id
2836: from csi_ii_relationships
2837: where subject_id = p_instance_id
2838: and relationship_type_code = 'COMPONENT-OF'
2839: and NVL(ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE
2840: AND NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE) ;