APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_VISIT_TASKS_B

Line 414: -- A Task can appear only once for a given visit (ahl_visit_tasks_b)

410: -- Enable Debug (optional)
411: Ahl_Debug_Pub.enable_debug;
412:
413: -- ASSUMPTIONS:
414: -- A Task can appear only once for a given visit (ahl_visit_tasks_b)
415: -- A Department can have only one shift (ahl_department_shifts)
416: -- Shift_Num is unique in bom_shift_times
417:
418: -- Validate Visit Id

Line 1798: FROM ahl_visit_tasks_b

1794: SELECT VISIT_ID
1795: FROM ahl_visits_b v
1796: WHERE (DEPARTMENT_ID = p_dept_id OR
1797: (DEPARTMENT_ID is not null and exists (select 1
1798: FROM ahl_visit_tasks_b
1799: where visit_id =v.visit_id
1800: AND department_id =p_dept_id
1801: AND nvl(status_code,'x') ='PLANNING'))) AND
1802: SIMULATION_PLAN_ID = p_plan_id AND

Line 1817: FROM ahl_visit_tasks_b

1813: SELECT VISIT_ID
1814: FROM ahl_visits_b a
1815: WHERE (DEPARTMENT_ID = p_dept_id OR
1816: (DEPARTMENT_ID is not null and exists (select 1
1817: FROM ahl_visit_tasks_b
1818: where visit_id =a.visit_id
1819: AND department_id =p_dept_id
1820: AND nvl(status_code,'x') ='PLANNING'))) AND
1821: SIMULATION_PLAN_ID IN (SELECT SIMULATION_PLAN_ID FROM ahl_simulation_plans_b WHERE

Line 2171: FROM ahl_visit_tasks_b vt

2167: NVL(start_from_hour, 0) start_from_hour,
2168: NVL(duration, 0) duration,
2169: start_date_time,
2170: end_date_time
2171: FROM ahl_visit_tasks_b vt
2172: WHERE vt.visit_id = p_visit_id AND
2173: status_code = 'PLANNING' AND
2174: (department_id = p_dept_id OR (department_id is NULL AND
2175: p_dept_id = (select department_id from ahl_visits_b

Line 2382: FROM ahl_visit_tasks_b a, ahl_mr_routes_app_v B

2378: ) IS
2379:
2380: CURSOR l_get_route_csr(p_task_id IN NUMBER) IS
2381: SELECT a.MR_ROUTE_ID,B.route_id
2382: FROM ahl_visit_tasks_b a, ahl_mr_routes_app_v B
2383: WHERE VISIT_TASK_ID = p_task_id
2384: AND a.mr_route_id = B.mr_route_id;
2385:
2386: CURSOR l_get_dept_csr(p_task_id IN NUMBER) IS

Line 2388: FROM ahl_visits_b v, ahl_visit_tasks_b vt

2384: AND a.mr_route_id = B.mr_route_id;
2385:
2386: CURSOR l_get_dept_csr(p_task_id IN NUMBER) IS
2387: SELECT vt.DEPARTMENT_ID,v.department_id,v.organization_id
2388: FROM ahl_visits_b v, ahl_visit_tasks_b vt
2389: WHERE vt.VISIT_TASK_ID = p_task_id
2390: AND v.visit_id = vt.visit_id;
2391:
2392: CURSOR l_get_rt_resources_csr(c_route_id IN NUMBER) IS