APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_VISITS_B

Line 381: SELECT 'x' FROM ahl_visits_b

377: x_msg_data OUT NOCOPY VARCHAR2
378: ) IS
379:
380: CURSOR l_validate_visit_csr(p_visit_id IN NUMBER) IS
381: SELECT 'x' FROM ahl_visits_b
382: WHERE VISIT_ID = p_visit_id;
383:
384: l_api_version CONSTANT NUMBER := 1.0;
385: l_api_name CONSTANT VARCHAR2(30) := 'Derive_Visit_Task_Times';

Line 1795: FROM ahl_visits_b v

1791: p_plan_id IN NUMBER,
1792: p_start_time IN DATE,
1793: p_end_time IN DATE) IS
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

Line 1814: FROM ahl_visits_b a

1810: p_plan_id IN NUMBER,
1811: p_start_time IN DATE,
1812: p_end_time IN DATE) IS
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

Line 1823: NOT EXISTS (SELECT 1 FROM ahl_visits_b WHERE SIMULATION_PLAN_ID = p_plan_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
1822: PRIMARY_PLAN_FLAG = G_PLAN_TYPE_PRIMARY) AND
1823: NOT EXISTS (SELECT 1 FROM ahl_visits_b WHERE SIMULATION_PLAN_ID = p_plan_id
1824: AND ASSO_PRIMARY_VISIT_ID = a.VISIT_ID) AND
1825: STATUS_CODE IN ('PLANNING','PARTIALLY RELEASED') AND
1826: START_DATE_TIME IS NOT NULL AND
1827: trunc(START_DATE_TIME) <= p_end_time AND

Line 2175: p_dept_id = (select department_id from ahl_visits_b

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
2176: where visit_id = p_visit_id))) AND
2177: mr_route_id is not null
2178: ORDER BY vt.visit_task_id;
2179:

Line 2185: FROM ahl_visits_b

2181: -- Added organization_id as select field and removed template_flag
2182:
2183: CURSOR l_visit_details_csr(p_visit_id IN NUMBER) IS
2184: SELECT start_date_time,department_id,close_date_time, organization_id
2185: FROM ahl_visits_b
2186: WHERE visit_id = p_visit_id;
2187:
2188:
2189: -- yazhou 24Aug2005 ends

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