eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_ROUTES_B

Line 3912: -- of ahl_routes_b table

3908: --
3909: END Aggregate_Task_Quantities;
3910: ----------------------------------------
3911: -- Gets the duration of a route from the timespan column
3912: -- of ahl_routes_b table
3913: ----------------------------------------
3914: PROCEDURE Get_Route_Duration
3915: (
3916: p_route_id IN NUMBER,

Line 3925: SELECT NVL(time_span, 0) FROM ahl_routes_b

3921: SELECT route_id FROM ahl_mr_routes_app_v
3922: WHERE mr_route_id = p_route_id;
3923:
3924: CURSOR l_route_time_span_csr (p_route_id IN NUMBER) IS
3925: SELECT NVL(time_span, 0) FROM ahl_routes_b
3926: WHERE route_id = p_route_id;
3927: x_route_id NUMBER;
3928: BEGIN
3929: