APPS.AHL_OSP_RCV_PVT dependencies on CSI_II_RELATIONSHIPS

Line 2557: from csi_ii_relationships

2553: WHERE instance_id = p_instance_id
2554: AND nvl(csi.active_end_date, sysdate + 1) > sysdate
2555: AND NOT EXISTS
2556: (select subject_id
2557: from csi_ii_relationships
2558: where subject_id = p_instance_id
2559: and relationship_type_code = 'COMPONENT-OF'
2560: and NVL(ACTIVE_START_DATE, SYSDATE - 1) < SYSDATE
2561: AND NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE) ;