APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ROUTES_APP_V

Line 3096: FROM ahl_routes_app_v

3092: IS
3093:
3094: CURSOR get_route_status(c_route_id number) IS
3095: SELECT revision_status_code
3096: FROM ahl_routes_app_v
3097: WHERE route_id = c_route_id;
3098: l_route_status_code VARCHAR2(30);
3099:
3100: BEGIN

Line 3365: FROM AHL_ROUTES_APP_V

3361:
3362: CURSOR get_route_time_span( c_route_id NUMBER )
3363: IS
3364: SELECT time_span
3365: FROM AHL_ROUTES_APP_V
3366: WHERE route_id = c_route_id;
3367:
3368: CURSOR get_op_route_time_span( c_operation_id NUMBER )
3369: IS

Line 3371: FROM AHL_ROUTES_APP_V RT, AHL_ROUTE_OPERATIONS ASS

3367:
3368: CURSOR get_op_route_time_span( c_operation_id NUMBER )
3369: IS
3370: SELECT MIN( RT.time_span )
3371: FROM AHL_ROUTES_APP_V RT, AHL_ROUTE_OPERATIONS ASS
3372: WHERE TRUNC ( NVL ( RT.end_date_active , SYSDATE + 1 ) ) > TRUNC( SYSDATE )
3373: AND RT.route_id = ASS.route_id
3374: AND ASS.operation_id = c_operation_id;
3375:

Line 3438: FROM AHL_ROUTES_APP_V

3434:
3435: CURSOR get_route_time_span( c_route_id NUMBER )
3436: IS
3437: SELECT time_span
3438: FROM AHL_ROUTES_APP_V
3439: WHERE route_id = c_route_id;
3440:
3441: -- Fix for bug# 6512803. Consider only scheduled resources.
3442: CURSOR get_op_max_duration( c_operation_id NUMBER )

Line 3496: FROM AHL_ROUTES_APP_V A, AHL_ROUTES_APP_V B

3492:
3493: CURSOR get_rt_latest_start_date( c_route_id NUMBER )
3494: IS
3495: SELECT MAX( A.start_date_active )
3496: FROM AHL_ROUTES_APP_V A, AHL_ROUTES_APP_V B
3497: WHERE A.route_no = B.route_no
3498: AND A.route_id <> c_route_id
3499: AND B.route_id = c_route_id;
3500:

Line 3934: FROM ahl_routes_app_v

3930: -- Cursor for selecting route id.
3931: CURSOR route_name_rev_csr_type (p_route_number IN VARCHAR2, p_route_revision IN NUMBER)
3932: IS
3933: SELECT route_id
3934: FROM ahl_routes_app_v
3935: WHERE UPPER( TRIM(route_no)) = UPPER(TRIM(p_route_number))
3936: AND
3937: revision_number = p_route_revision;
3938: