APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_MR_ROUTES

Line 340: FROM ahl_mr_routes mr,

336: --Bug Fix #4104968
337: CURSOR get_route_cur (c_visit_task_id IN NUMBER)
338: IS
339: SELECT route_id
340: FROM ahl_mr_routes mr,
341: ahl_visit_tasks_b vt
342: WHERE mr.mr_route_id = vt.mr_route_id
343: AND visit_task_id = c_visit_task_id;
344: --Modifed the cursor for Bug #4104968

Line 1169: FROM ahl_mr_routes_app_v mr

1165: /*B6271339 - sowsubra - Modified the cursor to fetch only the route id*/
1166: CURSOR Get_Routes_cur(c_mr_route_id IN NUMBER)
1167: IS
1168: SELECT mr.route_id
1169: FROM ahl_mr_routes_app_v mr
1170: WHERE mr.mr_route_id = C_MR_ROUTE_ID;
1171:
1172: CURSOR Visit_Valid_Cur(c_visit_id IN NUMBER)
1173: IS

Line 1513: ahl_mr_routes_app_v mr

1509: NVL(vt.start_date_time,vs.start_date_time) start_date_time,
1510: mr.route_id
1511: FROM ahl_visits_vl vs,
1512: ahl_visit_tasks_vl vt,
1513: ahl_mr_routes_app_v mr
1514: WHERE vs.visit_id = vt.visit_id
1515: AND vt.mr_route_id = mr.mr_route_id
1516: AND vt.unit_effectivity_id = nvl2(p_ue_id,-1,vt.unit_effectivity_id)
1517: AND vs.visit_id = c_visit_id

Line 1528: ahl_mr_routes_app_v mr

1524: NVL(vt.start_date_time,vs.start_date_time) start_date_time,
1525: mr.route_id
1526: FROM ahl_visits_vl vs,
1527: ahl_visit_tasks_vl vt,
1528: ahl_mr_routes_app_v mr
1529: WHERE vs.visit_id = vt.visit_id
1530: AND vt.mr_route_id = mr.mr_route_id
1531: AND vt.unit_effectivity_id IN
1532: (SELECT tsk2.unit_effectivity_id