APPS.AHL_COMPLETIONS_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 275: AHL_MR_HEADERS_APP_V MR,

271: /*CURSOR get_signoff_flag_csr(c_workorder_id IN NUMBER) IS
272: SELECT
273: MR.auto_signoff_flag
274: FROM
275: AHL_MR_HEADERS_APP_V MR,
276: AHL_VISIT_TASKS_B VT,
277: AHL_WORKORDERS WO
278: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
279: WO.VISIT_TASK_ID = VT.visit_task_id AND

Line 287: AHL_MR_HEADERS_APP_V MR,

283: CURSOR get_signoff_flag_csr(c_visit_task_id IN NUMBER) IS
284: SELECT
285: MR.auto_signoff_flag
286: FROM
287: AHL_MR_HEADERS_APP_V MR,
288: AHL_VISIT_TASKS_B VT
289: --AHL_WORKORDERS WO
290: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
291: VT.visit_task_id = c_visit_task_id;