APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISITS_VL

Line 1175: FROM ahl_visits_vl

1171:
1172: CURSOR Visit_Valid_Cur(c_visit_id IN NUMBER)
1173: IS
1174: SELECT 1
1175: FROM ahl_visits_vl
1176: WHERE visit_id = C_VISIT_ID
1177: AND (organization_id IS NULL
1178: OR start_date_time IS NULL);
1179:

Line 1511: FROM ahl_visits_vl vs,

1507: vt.mr_route_id,
1508: vt.instance_id,
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

Line 1526: FROM ahl_visits_vl vs,

1522: vt.mr_route_id,
1523: vt.instance_id,
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

Line 2649: FROM ahl_visits_vl vs,

2645: IS
2646: SELECT vs.visit_id,
2647: vs.organization_id,
2648: vt.visit_task_id
2649: FROM ahl_visits_vl vs,
2650: ahl_visit_tasks_vl vt
2651: WHERE vs.visit_id = vt.visit_id
2652: AND vs.visit_id = c_visit_id
2653: AND vt.visit_task_id = c_visit_task_id;