DBA Data[Home] [Help]

APPS.AHL_UMP_UTIL_PKG dependencies on AHL_SIMULATION_PLANS_B

Line 107: from ahl_visits_b vst1, ahl_simulation_plans_b sim

103: -- 11.5.10CU2: Ignore simulation visits.
104: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
105: SELECT vst.start_date_time, vst.visit_id
106: FROM ahl_visit_tasks_b tsk, (select vst1.*
107: from ahl_visits_b vst1, ahl_simulation_plans_b sim
108: where vst1.simulation_plan_id = sim.simulation_plan_id
109: and sim.primary_plan_flag = 'Y'
110: UNION ALL
111: select vst1.*

Line 182: from ahl_visits_b vst1, ahl_simulation_plans_b sim

178: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
179:
180: SELECT decode(vst.status_code,'CLOSED', vst.status_code, tsk.status_code)
181: FROM ahl_visit_tasks_b tsk, (select vst1.*
182: from ahl_visits_b vst1, ahl_simulation_plans_b sim
183: where vst1.simulation_plan_id = sim.simulation_plan_id
184: and sim.primary_plan_flag = 'Y'
185: UNION ALL
186: select vst1.*