APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_ROUTES_APP_V

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

Line 304: FROM AHL_ROUTES_APP_V rou ,

300: -- operation duration.
301: CURSOR get_asso_active_routes(c_oper_id IN NUMBER, c_op_duration IN NUMBER)
302: IS
303: SELECT rou.route_id
304: FROM AHL_ROUTES_APP_V rou ,
305: ahl_route_operations arop,
306: ahl_operations_b oper
307: WHERE (
308: TRUNC(rou.start_date_active) >= TRUNC(oper.start_date_active)

Line 651: FROM AHL_ROUTES_APP_V

647: AS
648: CURSOR get_route_det(c_route_id NUMBER)
649: IS
650: SELECT *
651: FROM AHL_ROUTES_APP_V
652: WHERE route_id = c_route_id;
653: l_route_rec get_route_det%rowtype;
654: l_msg VARCHAR2(30);
655: l_start_date DATE;

Line 872: FROM AHL_ROUTES_APP_V

868: IF l_route_rec.revision_status_code ='COMPLETE' or
869: l_route_rec.revision_Status_code='APPROVAL_TERMINATED'
870: THEN
871: SELECT COUNT(*) into l_counter
872: FROM AHL_ROUTES_APP_V
873: WHERE UPPER(TRIM(ROUTE_NO))=UPPER(TRIM(l_route_Rec.route_no))
874: AND REVISION_NUMBER=l_route_Rec.revision_number+1;
875:
876: IF l_counter>0

Line 1040: FROM AHL_ROUTES_APP_V

1036:
1037: CURSOR GetRouteDet(C_ROUTE_ID NUMBER)
1038: IS
1039: SELECT ROUTE_ID,ROUTE_NO,REVISION_NUMBER,START_DATE_ACTIVE,END_DATE_ACTIVE
1040: FROM AHL_ROUTES_APP_V
1041: WHERE ROUTE_ID=C_ROUTE_ID;
1042:
1043: CURSOR GetPrevRouteDet(C_REVISION_NUMBER NUMBER,C_ROUTE_NO VARCHAR2)
1044: IS

Line 1046: FROM AHL_ROUTES_APP_V

1042:
1043: CURSOR GetPrevRouteDet(C_REVISION_NUMBER NUMBER,C_ROUTE_NO VARCHAR2)
1044: IS
1045: SELECT ROUTE_ID,ROUTE_NO,REVISION_NUMBER,START_DATE_ACTIVE,END_DATE_ACTIVE
1046: FROM AHL_ROUTES_APP_V
1047: WHERE UPPER(TRIM(ROUTE_NO))=UPPER(TRIM(C_ROUTE_NO))
1048: AND REVISION_NUMBER=C_REVISION_NUMBER-1;
1049:
1050: l_route_rec GetRouteDet%rowtype;

Line 1105: FROM AHL_ROUTES_APP_V WHERE ROUTE_ID=p_route_id;

1101: AHL_DEBUG_PUB.enable_debug;
1102: END IF;
1103:
1104: SELECT REVISION_STATUS_CODE INTO l_curr_status
1105: FROM AHL_ROUTES_APP_V WHERE ROUTE_ID=p_route_id;
1106:
1107:
1108: IF p_appr_status='APPROVED'
1109: THEN