APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on CSI_II_RELATIONSHIPS

Line 834: FROM csi_ii_relationships

830: CURSOR get_unit_name_com (p_item_instance_id IN NUMBER) IS
831: SELECT unit_config_header_id, name
832: FROM ahl_unit_config_headers
833: WHERE csi_item_instance_id IN ( SELECT object_id
834: FROM csi_ii_relationships
835: START WITH subject_id = p_item_instance_id
836: AND relationship_type_code = 'COMPONENT-OF'
837: AND sysdate between trunc(nvl(active_start_date,sysdate))
838: AND trunc(nvl(active_end_date, SYSDATE+1))