APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_MR_HEADERS_B

Line 246: AHL_MR_HEADERS_B MRH

242: -- cursor to check for warranty template at MR header
243: CURSOR chk_wrrnty_tmpl_mr_csr (c_task_id NUMBER) IS
244: SELECT 'X'
245: FROM AHL_VISIT_TASKS_B TSK,
246: AHL_MR_HEADERS_B MRH
247: WHERE MRH.warranty_template_id IS NOT NULL
248: AND MRH.mr_header_id = TSK.mr_id
249: AND TSK.visit_task_id = c_task_id;
250: