APPS.AHL_VWP_TIMES_PVT dependencies on AHL_WORKORDERS

Line 135: FROM AHL_WORKORDERS

131:
132: -- Actual Visit Start Date
133: CURSOR get_actual_start_date_csr(c_visit_id IN NUMBER) IS
134: SELECT ACTUAL_START_DATE
135: FROM AHL_WORKORDERS
136: WHERE VISIT_ID = c_visit_id
137: AND VISIT_TASK_ID IS NULL
138: AND MASTER_WORKORDER_FLAG = 'Y';
139:

Line 226: FROM AHL_WORKORDERS WO,

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

Line 240: FROM AHL_WORKORDERS

236: -- Begin changes by rnahata for Bug 6430038
237: -- Actual Visit End Date
238: CURSOR get_actual_end_date_csr(c_visit_id IN NUMBER) IS
239: SELECT ACTUAL_END_DATE
240: FROM AHL_WORKORDERS
241: WHERE VISIT_ID = c_visit_id
242: AND VISIT_TASK_ID IS NULL
243: AND MASTER_WORKORDER_FLAG = 'Y';
244: --

Line 446: FROM AHL_WORKORDERS WO,

442: IS
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