APPS.AHL_UMP_UTIL_PKG dependencies on AHL_VISITS_B

Line 116: from ahl_visits_b vst1, ahl_simulation_plans_b sim

112: -- 11.5.10CU2: Ignore simulation visits.
113: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
114: SELECT vst.start_date_time, vst.visit_id, tsk.status_code
115: FROM ahl_visit_tasks_b tsk, (select vst1.*
116: from ahl_visits_b vst1, ahl_simulation_plans_b sim
117: where vst1.simulation_plan_id = sim.simulation_plan_id
118: and sim.primary_plan_flag = 'Y'
119: UNION ALL
120: select vst1.*

Line 121: from ahl_visits_b vst1

117: where vst1.simulation_plan_id = sim.simulation_plan_id
118: and sim.primary_plan_flag = 'Y'
119: UNION ALL
120: select vst1.*
121: from ahl_visits_b vst1
122: where vst1.simulation_plan_id IS NULL) vst
123: WHERE vst.visit_id = tsk.visit_id
124: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
125: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')

Line 217: l_visit_status_code AHL_VISITS_B.STATUS_CODE%TYPE;

213:
214: IS
215:
216: --l_ump_visit_rec AHL_VWP_VISITS_PVT.Srch_UMP_rec_type;
217: l_visit_status_code AHL_VISITS_B.STATUS_CODE%TYPE;
218: l_return_status VARCHAR2(1);
219: l_msg_count NUMBER;
220: l_msg_data VARCHAR2(2000);
221:

Line 227: from ahl_visits_b vst1, ahl_simulation_plans_b sim

223: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
224:
225: SELECT decode(vst.status_code,'CLOSED', vst.status_code, tsk.status_code)
226: FROM ahl_visit_tasks_b tsk, (select vst1.*
227: from ahl_visits_b vst1, ahl_simulation_plans_b sim
228: where vst1.simulation_plan_id = sim.simulation_plan_id
229: and sim.primary_plan_flag = 'Y'
230: UNION ALL
231: select vst1.*

Line 232: from ahl_visits_b vst1

228: where vst1.simulation_plan_id = sim.simulation_plan_id
229: and sim.primary_plan_flag = 'Y'
230: UNION ALL
231: select vst1.*
232: from ahl_visits_b vst1
233: where vst1.simulation_plan_id IS NULL) vst
234: WHERE vst.visit_id = tsk.visit_id
235: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
236: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')

Line 240: FROM ahl_visit_tasks_b tsk, ahl_visits_b vst

236: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
237: AND tsk.task_type_code = 'SUMMARY'
238: AND tsk.unit_effectivity_id = p_ue_id;
239: /*
240: FROM ahl_visit_tasks_b tsk, ahl_visits_b vst
241: WHERE vst.visit_id = tsk.visit_id
242: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
243: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
244: AND tsk.unit_effectivity_id = p_ue_id;