APPS.AHL_OSP_ACCOMP_PVT dependencies on CSI_II_RELATIONSHIPS

Line 780: SELECT subject_id from csi_ii_relationships

776:
777: CURSOR get_instance_descendants_csr (c_instance_id NUMBER) IS
778: SELECT c_instance_id from DUAL
779: UNION
780: SELECT subject_id from csi_ii_relationships
781: WHERE relationship_type_code = 'COMPONENT-OF'
782: AND NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE
783: AND NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE
784: START WITH object_id = c_instance_id