APPS.AHL_UMP_UTIL_PKG dependencies on AHL_VISITS_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 112: from ahl_visits_b vst1

108: where vst1.simulation_plan_id = sim.simulation_plan_id
109: and sim.primary_plan_flag = 'Y'
110: UNION ALL
111: select vst1.*
112: from ahl_visits_b vst1
113: where vst1.simulation_plan_id IS NULL) vst
114: WHERE vst.visit_id = tsk.visit_id
115: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
116: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')

Line 172: l_visit_status_code AHL_VISITS_B.STATUS_CODE%TYPE;

168:
169: IS
170:
171: --l_ump_visit_rec AHL_VWP_VISITS_PVT.Srch_UMP_rec_type;
172: l_visit_status_code AHL_VISITS_B.STATUS_CODE%TYPE;
173: l_return_status VARCHAR2(1);
174: l_msg_count NUMBER;
175: l_msg_data VARCHAR2(2000);
176:

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.*

Line 187: from ahl_visits_b vst1

183: where vst1.simulation_plan_id = sim.simulation_plan_id
184: and sim.primary_plan_flag = 'Y'
185: UNION ALL
186: select vst1.*
187: from ahl_visits_b vst1
188: where vst1.simulation_plan_id IS NULL) vst
189: WHERE vst.visit_id = tsk.visit_id
190: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
191: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')

Line 194: FROM ahl_visit_tasks_b tsk, ahl_visits_b vst

190: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
191: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
192: AND tsk.unit_effectivity_id = p_ue_id;
193: /*
194: FROM ahl_visit_tasks_b tsk, ahl_visits_b vst
195: WHERE vst.visit_id = tsk.visit_id
196: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
197: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')
198: AND tsk.unit_effectivity_id = p_ue_id;