APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on CS_INCIDENT_STATUSES_TL

Line 453: l_status_name cs_incident_statuses_tl.name%type;

449: l_object_version_number CS_INCIDENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
450: l_incident_status_id CS_INCIDENTS_ALL_B.INCIDENT_ID%TYPE;
451: -- End Of Fix Bug#5007335
452:
453: l_status_name cs_incident_statuses_tl.name%type;
454: l_interaction_id NUMBER;
455: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
456: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
457: l_notes_table CS_ServiceRequest_PUB.notes_table;

Line 584: from cs_incident_statuses_tl

580: CURSOR c_service_status
581: IS
582: select incident_status_id,
583: name
584: from cs_incident_statuses_tl
585: -- where name = 'Planned';
586: where incident_status_id = 52
587: and language = userenv('lang');
588: