APPS.AHL_VWP_TIMES_PVT dependencies on AHL_VISITS_B

Line 153: FROM AHL_VISITS_B

149: --
150: -- To get the Start Date and Status of the Visit
151: CURSOR c_visit_csr (c_visit_id IN NUMBER) IS
152: SELECT START_DATE_TIME, STATUS_CODE
153: FROM AHL_VISITS_B
154: WHERE VISIT_ID = c_visit_id;
155:
156: -- Actual Visit Start Date
157: CURSOR get_actual_start_date_csr(c_visit_id IN NUMBER) IS

Line 326: FROM AHL_VISITS_B

322: -- SKPATHAK :: 12-MAY-2011 :: VWPE: ER:12424063 :: Modified the below cursor
323: --Cursor for fetching visit start and end dates
324: CURSOR get_visit_dates(x_visit_id IN NUMBER) IS
325: SELECT past_dated_visit_flag, start_date_time, close_date_time
326: FROM AHL_VISITS_B
327: WHERE visit_id = x_visit_id;
328: visit_dates_rec get_visit_dates%ROWTYPE;
329:
330: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063

Line 511: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt

507: -- PRAKKUM :: BUG Internal (also fixed #13595460):: 19/01/2012 :: Task Time Adjustments Not Required For Tasks those that have workorders
508: -- already since scheduling will be taken care of by PS if the task has a WO :: START
509: /*CURSOR get_visit_dets(p_task_id IN NUMBER) IS
510: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time
511: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt
512: WHERE v.visit_id = vt.visit_id
513: AND vt.visit_task_id = p_task_id;*/
514: CURSOR get_visit_dets(p_task_id IN NUMBER) IS
515: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time

Line 516: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt

512: WHERE v.visit_id = vt.visit_id
513: AND vt.visit_task_id = p_task_id;*/
514: CURSOR get_visit_dets(p_task_id IN NUMBER) IS
515: SELECT v.visit_id, v.past_dated_visit_flag, v.status_code, v.start_date_time, v.close_date_time
516: FROM AHL_VISITS_B v, AHL_VISIT_TASKS_B vt
517: , ahl_workorders wo
518: WHERE v.visit_id = vt.visit_id
519: AND vt.visit_task_id = p_task_id
520: AND vt.visit_task_id = wo.visit_task_id(+)

Line 682: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,

678: nvl(vt.department_id, v.department_id),
679: nvl(vt.duration, NVL(Get_task_duration(vt.quantity, routes.route_id), 0)) duration,
680: vt.stage_id,
681: nvl(vt.start_from_hour, 0)
682: FROM AHL_VISIT_TASKS_B vt, AHL_VISITS_B v,
683: ahl_routes_app_v routes, ahl_mr_routes_app_v mr
684: WHERE vt.visit_id = v.visit_id
685: AND routes.route_id (+) = mr.route_id
686: AND mr.mr_route_id (+)= vt.mr_route_id

Line 855: FROM AHL_VISITS_B

851: IS
852: --
853: CURSOR get_all_visits_csr(p_dept_id IN NUMBER) IS
854: SELECT visit_id
855: FROM AHL_VISITS_B
856: WHERE DEPARTMENT_ID = p_dept_id
857: UNION
858: SELECT visit_id
859: FROM AHL_VISIT_TASKS_B