APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CS_INCIDENT_STATUSES_TL

Line 464: l_status_name cs_incident_statuses_tl.name%type;

460: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
461: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
462: -- End Of Fix Bug#5007335
463:
464: l_status_name cs_incident_statuses_tl.name%type;
465: l_interaction_id NUMBER;
466: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
467: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
468: l_notes_table CS_ServiceRequest_PUB.notes_table;

Line 595: from cs_incident_statuses_tl

591: CURSOR c_service_status
592: IS
593: select incident_status_id,
594: name
595: from cs_incident_statuses_tl
596: -- where name = 'Planned';
597: where incident_status_id = 52
598: and language = userenv('lang');
599: