APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_MR_ROUTES

Line 280: FROM ahl_mr_routes mr,

276: --Bug Fix #4104968
277: CURSOR get_route_cur (c_visit_task_id IN NUMBER)
278: IS
279: SELECT route_id
280: FROM ahl_mr_routes mr,
281: ahl_visit_tasks_b vt
282: WHERE mr.mr_route_id = vt.mr_route_id
283: AND visit_task_id = c_visit_task_id;
284: --Modifed the cursor for Bug #4104968

Line 1158: FROM ahl_mr_routes_app_v mr

1154: /*B6271339 - sowsubra - Modified the cursor to fetch only the route id*/
1155: CURSOR Get_Routes_cur(c_mr_route_id IN NUMBER)
1156: IS
1157: SELECT mr.route_id
1158: FROM ahl_mr_routes_app_v mr
1159: WHERE mr.mr_route_id = C_MR_ROUTE_ID;
1160:
1161: CURSOR Visit_Valid_Cur(c_visit_id IN NUMBER)
1162: IS

Line 1492: ahl_mr_routes_app_v mr

1488: mr.route_id
1489:
1490: FROM ahl_visits_vl vs,
1491: ahl_visit_tasks_vl vt,
1492: ahl_mr_routes_app_v mr
1493: WHERE vs.visit_id = vt.visit_id
1494: AND vt.mr_route_id = mr.mr_route_id
1495: AND vs.visit_id = C_VISIT_ID
1496: -- Modified by amagrawa based on Enhancement

Line 1505: ahl_mr_routes_app_v mr

1501: SELECT mr.route_id,
1502: vt.instance_id,
1503: vt.start_date_time
1504: FROM ahl_visit_tasks_vl vt,
1505: ahl_mr_routes_app_v mr
1506: WHERE vt.mr_route_id = mr.mr_route_id
1507: AND mr.mr_route_id = C_MR_ROUTE_ID;
1508:
1509: -- yazhou 17-May-2006 starts