APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WARRANTY_ENTITLEMENTS

Line 4702: from ahl_warranty_entitlements

4698:
4699: -- ER#10257011 Supplier Warranty manisaga
4700: CURSOR get_entitlement_id(p_visit_task_id NUMBER) IS
4701: SELECT warranty_entitlement_id ,object_version_number
4702: from ahl_warranty_entitlements
4703: where visit_task_id = p_visit_task_id;
4704:
4705: -- JKJain, NR Analysis and Forecasting
4706: CURSOR get_uc_fleet_mntnc_csr(p_wo_id NUMBER) IS

Line 11989: FROM AHL_WARRANTY_ENTITLEMENTS

11985:
11986: CURSOR get_old_entl_details(c_visit_task_id NUMBER) IS
11987: SELECT ENTITLEMENT_STATUS_CODE,
11988: WARRANTY_CONTRACT_ID
11989: FROM AHL_WARRANTY_ENTITLEMENTS
11990: where VISIT_TASK_ID = c_visit_task_id;
11991:
11992: CURSOR get_sr_incident_id(c_visit_task_id NUMBER) IS
11993: SELECT service_request_id