APPS.AHL_VWP_TASKS_PVT dependencies on AHL_WARRANTY_ENTITLEMENTS

Line 963: AHL_WARRANTY_ENTITLEMENTS ASWE,

959: NVL2(TO_NUMBER(ASWE.WARRANTY_ENTITLEMENT_ID)
960: , DECODE(ASWE.ENTITLEMENT_STATUS_CODE, 'NOT_APPLICABLE', 'Y', 'N')
961: , 'Y') WARRANTY_NOT_APPL_FLAG
962: FROM AHL_VISIT_TASKS_VL ATSK,
963: AHL_WARRANTY_ENTITLEMENTS ASWE,
964: AHL_WARRANTY_CLAIMS_B AWCL,
965: AHL_WARRANTY_CONTRACTS_B AWCB,
966: FND_LOOKUP_VALUES_VL LKUP1,
967: FND_LOOKUP_VALUES_VL LKUP2

Line 9875: FROM AHL_WARRANTY_ENTITLEMENTS AWSE

9871: -- Cursors defined for the procedure
9872: -- Cursor to fetch entitlemet details
9873: CURSOR c_get_warranty_entl_id (c_task_id IN NUMBER) IS
9874: SELECT AWSE.WARRANTY_ENTITLEMENT_ID, AWSE.SR_INCIDENT_ID, AWSE.OBJECT_VERSION_NUMBER
9875: FROM AHL_WARRANTY_ENTITLEMENTS AWSE
9876: WHERE AWSE.VISIT_TASK_ID = c_task_id;
9877:
9878: BEGIN
9879: --------------------Start of API Body-----------------------------------