[Home] [Help]
14135: --Cursors defined for the procedure
14136: --Cursor to fetch entitlement details based on Sr Incident Id
14137: CURSOR c_get_entl_details (c_sr_incident_id IN NUMBER) IS
14138: SELECT AWSE.WARRANTY_ENTITLEMENT_ID, AWSE.VISIT_TASK_ID
14139: FROM AHL_WARRANTY_ENTITLEMENTS AWSE
14140: WHERE AWSE.SR_INCIDENT_ID = c_sr_incident_id;
14141:
14142: --Cursor to fetch SR Id's of Visit
14143: CURSOR get_sr_ids (c_visit_id IN NUMBER) IS