APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_VISITS_B

Line 436: SELECT WO.visit_id,VWP.organization_id FROM AHL_WORKORDERS WO,AHL_VISITS_B VWP

432: WHERE unit_config_header_id = c_unit_header_id;
433:
434: --Cursor to get basic details
435: CURSOR get_visit_details_csr IS
436: SELECT WO.visit_id,VWP.organization_id FROM AHL_WORKORDERS WO,AHL_VISITS_B VWP
437: WHERE WO.workorder_id = p_workorder_id
438: AND WO.visit_id = VWP.visit_id;
439:
440: CURSOR get_part_info(c_instance_id NUMBER) IS