APPS.AHL_PRD_VISITS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 118: FROM csi_ii_relationships

114: CURSOR get_unit_name_csr (p_csi_item_instance_id IN NUMBER) IS
115: SELECT name
116: FROM ahl_unit_config_headers uc
117: WHERE csi_item_instance_id in ( SELECT object_id
118: FROM csi_ii_relationships
119: START WITH object_id = p_csi_item_instance_id
120: AND relationship_type_code = 'COMPONENT-OF'
121: CONNECT BY PRIOR subject_id = object_id
122: AND relationship_type_code = 'COMPONENT-OF'