APPS.AHL_UMP_UTIL_PKG dependencies on AHL_VISIT_TASKS_B

Line 115: FROM ahl_visit_tasks_b tsk, (select vst1.*

111:
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

Line 134: from ahl_workorders awo, ahl_visit_tasks_b tsk

130: CURSOR get_wo_dt (p_unit_effectivity_id IN NUMBER) IS
131: SELECT max(scheduled_completion_date)
132: FROM wip_discrete_jobs
133: WHERE wip_entity_id IN (select wip_entity_id
134: from ahl_workorders awo, ahl_visit_tasks_b tsk
135: where awo.visit_task_id = tsk.visit_task_id
136: and tsk.task_type_code <> 'SUMMARY'
137: and awo.status_code NOT IN ('17','22','7')
138: and tsk.unit_effectivity_id = p_unit_effectivity_id);

Line 141: l_tsk_status_code ahl_visit_tasks_b.status_code%TYPE;

137: and awo.status_code NOT IN ('17','22','7')
138: and tsk.unit_effectivity_id = p_unit_effectivity_id);
139:
140: l_mwo_end_date DATE;
141: l_tsk_status_code ahl_visit_tasks_b.status_code%TYPE;
142:
143:
144: begin
145:

Line 226: FROM ahl_visit_tasks_b tsk, (select vst1.*

222: -- 11.5.10CU2: Ignore simulation visits.
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

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;