APPS.AHL_PRD_VISITS_PVT dependencies on AHL_WORKORDERS

Line 224: SELECT WORKORDER_NAME, WORKORDER_ID FROM AHL_WORKORDERS

220: visit_rec c_visit_details%ROWTYPE;
221:
222: -- Cursor to find master workorder name for the given visit
223: CURSOR c_workorder_csr (x_id IN NUMBER) IS
224: SELECT WORKORDER_NAME, WORKORDER_ID FROM AHL_WORKORDERS
225: WHERE MASTER_WORKORDER_FLAG = 'Y' AND VISIT_ID = x_id;
226:
227: -- CURSOR added to get the Project Template Name
228: -- Post 11.5.10