APPS.AHL_COMPLEX_MX_PVT dependencies on WIP_DISCRETE_JOBS

Line 808: from ahl_visit_tasks_b vts, ahl_workorders wo, wip_discrete_jobs wdj

804:
805: CURSOR C_Visit_End_Date(p_visit_id NUMBER)
806: IS
807: select max(nvl(wdj.scheduled_completion_date,vts.end_date_time))
808: from ahl_visit_tasks_b vts, ahl_workorders wo, wip_discrete_jobs wdj
809: where
810: vts.visit_id = p_visit_id
811: and vts.return_to_supply_flag = 'Y'
812: and vts.status_code <> 'DELETED'