APPS.AHL_VWP_TIMES_PVT dependencies on AHL_VISITS_B

Line 129: FROM AHL_VISITS_B

125: --
126: -- To get the Start Date and Status of the Visit
127: CURSOR c_visit_csr (c_visit_id IN NUMBER) IS
128: SELECT START_DATE_TIME, STATUS_CODE
129: FROM AHL_VISITS_B
130: WHERE VISIT_ID = c_visit_id;
131:
132: -- Actual Visit Start Date
133: CURSOR get_actual_start_date_csr(c_visit_id IN NUMBER) IS

Line 213: FROM AHL_VISITS_B

209: --
210: -- To find visit related information
211: CURSOR c_visit_csr (c_id IN NUMBER) IS
212: SELECT CLOSE_DATE_TIME, START_DATE_TIME, DEPARTMENT_ID, status_code
213: FROM AHL_VISITS_B
214: WHERE VISIT_ID = c_id;
215: --
216: CURSOR get_end_date_csr(c_visit_id IN NUMBER) IS
217: SELECT MAX(end_date_time)

Line 379: FROM AHL_VISITS_B v, AHL_DEPARTMENT_SHIFTS shifts

375: --
376: --Fetch basic visit data
377: CURSOR get_visit_data_csr(p_visit_id IN NUMBER) IS
378: SELECT v.start_date_time, v.department_id
379: FROM AHL_VISITS_B v, AHL_DEPARTMENT_SHIFTS shifts
380: WHERE v.department_id = shifts.department_id
381: AND v.visit_id = p_visit_id;
382: --
383: --Cursor for deriving all the stage start hours

Line 676: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt, AHL_DEPARTMENT_SHIFTS dept

672: --
673: --Cursor for fetching visit info
674: CURSOR get_visit_data_csr(p_task_id IN NUMBER) IS
675: SELECT v.start_date_time, v.department_id, v.visit_id, v.status_code
676: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt, AHL_DEPARTMENT_SHIFTS dept
677: WHERE v.visit_id = vt.visit_id
678: AND dept.department_id = v.department_id
679: AND vt.visit_task_id = p_task_id;
680: --

Line 817: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,

813: /*B6182718 - sowsubra*/
814: nvl(vt.duration, NVL(Get_task_duration(vt.quantity, routes.route_id), 0)) duration,
815: vt.stage_id,
816: nvl(vt.start_from_hour, 0)
817: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,
818: ahl_routes_app_v routes, ahl_mr_routes_app_v mr
819: WHERE vt.visit_id = v.visit_id
820: AND routes.route_id (+) = mr.route_id
821: AND mr.mr_route_id (+)= vt.mr_route_id

Line 982: FROM AHL_VISITS_B

978: IS
979: --
980: CURSOR get_all_visits_csr(p_dept_id IN NUMBER) IS
981: SELECT visit_id
982: FROM AHL_VISITS_B
983: WHERE DEPARTMENT_ID = p_dept_id
984: UNION
985: SELECT visit_id
986: FROM AHL_VISIT_TASKS_B