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 595: FROM AHL_ROUTES_APP_V

591: AS
592: CURSOR get_route_det(c_route_id NUMBER)
593: IS
594: SELECT *
595: FROM AHL_ROUTES_APP_V
596: WHERE route_id = c_route_id;
597: l_route_rec get_route_det%rowtype;
598: l_msg VARCHAR2(30);
599: l_start_date DATE;

Line 814: FROM AHL_ROUTES_APP_V

810: IF l_route_rec.revision_status_code ='COMPLETE' or
811: l_route_rec.revision_Status_code='APPROVAL_TERMINATED'
812: THEN
813: SELECT COUNT(*) into l_counter
814: FROM AHL_ROUTES_APP_V
815: WHERE UPPER(TRIM(ROUTE_NO))=UPPER(TRIM(l_route_Rec.route_no))
816: AND REVISION_NUMBER=l_route_Rec.revision_number+1;
817:
818: IF l_counter>0

Line 982: FROM AHL_ROUTES_APP_V

978:
979: CURSOR GetRouteDet(C_ROUTE_ID NUMBER)
980: IS
981: SELECT ROUTE_ID,ROUTE_NO,REVISION_NUMBER,START_DATE_ACTIVE,END_DATE_ACTIVE
982: FROM AHL_ROUTES_APP_V
983: WHERE ROUTE_ID=C_ROUTE_ID;
984:
985: CURSOR GetPrevRouteDet(C_REVISION_NUMBER NUMBER,C_ROUTE_NO VARCHAR2)
986: IS

Line 988: FROM AHL_ROUTES_APP_V

984:
985: CURSOR GetPrevRouteDet(C_REVISION_NUMBER NUMBER,C_ROUTE_NO VARCHAR2)
986: IS
987: SELECT ROUTE_ID,ROUTE_NO,REVISION_NUMBER,START_DATE_ACTIVE,END_DATE_ACTIVE
988: FROM AHL_ROUTES_APP_V
989: WHERE UPPER(TRIM(ROUTE_NO))=UPPER(TRIM(C_ROUTE_NO))
990: AND REVISION_NUMBER=C_REVISION_NUMBER-1;
991:
992: l_route_rec GetRouteDet%rowtype;

Line 1047: FROM AHL_ROUTES_APP_V WHERE ROUTE_ID=p_route_id;

1043: AHL_DEBUG_PUB.enable_debug;
1044: END IF;
1045:
1046: SELECT REVISION_STATUS_CODE INTO l_curr_status
1047: FROM AHL_ROUTES_APP_V WHERE ROUTE_ID=p_route_id;
1048:
1049:
1050: IF p_appr_status='APPROVED'
1051: THEN