APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_VISIT_TASKS_B
Line 37: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D
33:
34: CURSOR CurRoute
35: is
36: SELECT C.*,D.VISIT_NUMBER 37: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D 38: WHERE A.ROUTE_ID=p_activity_id
39: AND A.ROUTE_ID=B.ROUTE_ID
40: AND B.MR_ROUTE_ID=C.MR_ROUTE_ID
41: AND C.VISIT_ID=D.VISIT_ID
Line 57: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D,AHL_ROUTE_OPERATIONS E
53:
54: CURSOR CurOper
55: is
56: SELECT C.*,D.VISIT_NUMBER 57: FROM AHL_ROUTES_APP_V A,AHL_MR_ROUTES B,AHL_VISIT_TASKS_B C,AHL_VISITS_VL D,AHL_ROUTE_OPERATIONS E 58: WHERE A.ROUTE_ID=B.ROUTE_ID
59: AND A.ROUTE_ID=E.ROUTE_ID
60: AND B.MR_ROUTE_ID=C.MR_ROUTE_ID
61: AND C.VISIT_ID=D.VISIT_ID