APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_VISIT_TASKS_B

Line 245: FROM AHL_VISIT_TASKS_B TSK,

241:
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;

Line 254: FROM AHL_VISIT_TASKS_B TSK,

250:
251: -- cursor to check for warranty template at Route
252: CURSOR chk_wrrnty_tmpl_route_csr (c_task_id NUMBER) IS
253: SELECT 'X'
254: FROM AHL_VISIT_TASKS_B TSK,
255: AHL_MR_ROUTES MRR,
256: AHL_ROUTES_B ROUTE
257: WHERE ROUTE.warranty_template_id IS NOT NULL
258: AND ROUTE.route_id = MRR.route_id

Line 744: FROM AHL_VISIT_TASKS_B VTK, AHL_WARRANTY_ENTITLEMENTS ENT

740: ) RETURN NUMBER IS
741:
742: CURSOR get_visit_task_inst_csr (c_entl_id NUMBER) IS
743: SELECT VTK.instance_id
744: FROM AHL_VISIT_TASKS_B VTK, AHL_WARRANTY_ENTITLEMENTS ENT
745: WHERE VTK.visit_task_id = ENT.visit_task_id
746: AND ENT.warranty_entitlement_id = c_entl_id;
747:
748: CURSOR get_osp_line_inst_csr (c_entl_id NUMBER) IS

Line 750: FROM AHL_VISIT_TASKS_B VTK, AHL_WORKORDERS WO,

746: AND ENT.warranty_entitlement_id = c_entl_id;
747:
748: CURSOR get_osp_line_inst_csr (c_entl_id NUMBER) IS
749: SELECT VTK.instance_id
750: FROM AHL_VISIT_TASKS_B VTK, AHL_WORKORDERS WO,
751: AHL_OSP_ORDER_LINES OSP, AHL_WARRANTY_ENTITLEMENTS ENT
752: WHERE VTK.visit_task_id = WO.visit_task_id
753: AND WO.workorder_id = OSP.workorder_id
754: AND OSP.workorder_id IS NOT NULL

Line 1760: FROM AHL_VISIT_TASKS_B

1756: AND incident_status_id <> 2; -- Closed status
1757:
1758: CURSOR chk_visit_tsk_id_csr (c_task_id NUMBER) IS
1759: SELECT 'X'
1760: FROM AHL_VISIT_TASKS_B
1761: WHERE visit_task_id = c_task_id
1762: AND status_code NOT IN ('CANCELLED', 'DELETED');
1763:
1764: CURSOR chk_workorder_id_csr (c_wo_id NUMBER) IS