APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_VISITS_B

Line 1262: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W

1258: CURSOR c_wo_dept (x_id IN NUMBER) IS
1259: SELECT --V.DEPARTMENT_ID, -- department should be from wip_operations
1260: V.ORGANIZATION_ID,
1261: WORKORDER_NAME, WIP_ENTITY_ID FROM
1262: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W
1263: WHERE W.VISIT_TASK_ID = T.VISIT_TASK_ID AND T.VISIT_ID = V.VISIT_ID
1264: AND W.VISIT_TASK_ID = x_id;
1265:
1266: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table

Line 2335: AHL_VISITS_B C

2331: CURSOR c_work_orders (x_id IN NUMBER) IS
2332: SELECT WIP_ENTITY_ID,WORKORDER_NAME,
2333: ORGANIZATION_ID FROM
2334: AHL_WORKORDERS A, AHL_VISIT_TASKS_B B,
2335: AHL_VISITS_B C
2336: WHERE WORKORDER_ID = x_id
2337: AND A.VISIT_TASK_ID = B.VISIT_TASK_ID
2338: AND B.VISIT_ID = C.VISIT_ID;
2339: