APPS.AHL_VWP_TIMES_PVT dependencies on WIP_DISCRETE_JOBS

Line 227: WIP_DISCRETE_JOBS WIP,

223: -- Added by yazhou Sept-21-2004
224: CURSOR get_wo_end_date_csr(c_visit_id IN NUMBER) IS
225: SELECT MAX(WIP.SCHEDULED_COMPLETION_DATE)
226: FROM AHL_WORKORDERS WO,
227: WIP_DISCRETE_JOBS WIP,
228: AHL_VISIT_TASKS_B VT
229: WHERE vt.status_code = 'RELEASED'
230: AND vt.VISIT_ID = c_visit_id
231: AND vt.visit_task_id = wo.VISIT_TASK_ID

Line 447: WIP_DISCRETE_JOBS WIP,

443: SELECT vt.VISIT_TASK_ID,
444: WIP.SCHEDULED_START_DATE,
445: WIP.SCHEDULED_COMPLETION_DATE
446: FROM AHL_WORKORDERS WO,
447: WIP_DISCRETE_JOBS WIP,
448: AHL_VISIT_TASKS_B VT
449: WHERE vt.status_code = 'RELEASED'
450: AND vt.VISIT_ID = P_VISIT_ID
451: AND vt.visit_task_id = wo.VISIT_TASK_ID(+)