DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_WARRANTY_ENTITLEMENTS

Line 2368: FROM AHL_WARRANTY_ENTITLEMENTS

2364: --
2365: CURSOR Get_warranty_entl_rec_csr (c_sr_incident_id NUMBER)
2366: IS
2367: SELECT warranty_entitlement_id, object_version_number, visit_task_id
2368: FROM AHL_WARRANTY_ENTITLEMENTS
2369: WHERE sr_incident_id = c_sr_incident_id;
2370: --
2371: CURSOR Get_contract_id_csr (c_originating_wo_id NUMBER)
2372: IS

Line 2374: FROM AHL_WARRANTY_ENTITLEMENTS

2370: --
2371: CURSOR Get_contract_id_csr (c_originating_wo_id NUMBER)
2372: IS
2373: SELECT warranty_contract_id
2374: FROM AHL_WARRANTY_ENTITLEMENTS
2375: WHERE visit_task_id = (SELECT visit_task_id
2376: FROM AHL_WORKORDERS
2377: WHERE workorder_id = c_originating_wo_id);
2378: --