APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MR_ROUTES

Line 517: select route_id from ahl_mr_routes

513: p_request_type IN VARCHAR2,
514: x_route_id OUT NOCOPY NUMBER) IS
515:
516: CURSOR get_route_id_csr IS
517: select route_id from ahl_mr_routes
518: where mr_route_id = p_mr_route_id;
519:
520: CURSOR validate_route_id_csr(c_route_id IN NUMBER) IS
521: -- Changes by skpathak on 06-NOV-2008 for bug-7336824