APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_VISITS_B

Line 1084: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W

1080: CURSOR c_wo_dept (x_id IN NUMBER) IS
1081: SELECT --V.DEPARTMENT_ID, -- department should be from wip_operations
1082: V.ORGANIZATION_ID,
1083: WORKORDER_NAME, WIP_ENTITY_ID FROM
1084: AHL_VISITS_B V, AHL_VISIT_TASKS_B T, AHL_WORKORDERS W
1085: WHERE W.VISIT_TASK_ID = T.VISIT_TASK_ID AND T.VISIT_ID = V.VISIT_ID
1086: AND W.VISIT_TASK_ID = x_id;
1087:
1088: -- To find the UOM_CODE from MTL_UNITS_OF_MEASURE table

Line 2137: AHL_VISITS_B C

2133: CURSOR c_work_orders (x_id IN NUMBER) IS
2134: SELECT WIP_ENTITY_ID,WORKORDER_NAME,
2135: ORGANIZATION_ID FROM
2136: AHL_WORKORDERS A, AHL_VISIT_TASKS_B B,
2137: AHL_VISITS_B C
2138: WHERE WORKORDER_ID = x_id
2139: AND A.VISIT_TASK_ID = B.VISIT_TASK_ID
2140: AND B.VISIT_ID = C.VISIT_ID;
2141: