APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_STATUSES_TL

Line 664: , cs_incident_statuses_tl status

660: , cs_sr_link_types_tl ltype
661: , fnd_user fnd1
662: , cs_incidents_all_b relSR
663: , cs_incidents_all_tl tlSR
664: , cs_incident_statuses_tl status
665: , cs_incident_severities_tl severity
666: WHERE SrLnkEO.subject_id = x_incident_id
667: AND SrLnkEO.subject_type = 'SR'
668: AND SrLnkEO.object_type = 'SR'

Line 1067: FROM cs_incident_statuses_tl status, cs_incident_statuses_b status_b

1063: --:Incident_Status
1064: --:status_sort_order
1065: CURSOR Get_Inc_Status ( v_incident_status_id NUMBER) IS
1066: SELECT status.name ,status_b.sort_order
1067: FROM cs_incident_statuses_tl status, cs_incident_statuses_b status_b
1068: WHERE status.incident_status_id = v_incident_status_id
1069: AND status.incident_status_id = status_b.incident_status_id
1070: AND status.language = userenv('LANG');
1071:

Line 1424: FROM cs_incident_statuses_tl status

1420: ,(SELECT type.detailed_erecord_req_flag
1421: FROM cs_incident_types_b type
1422: WHERE type.incident_type_id = sr.incident_type_id) Detailed_Erecord
1423: ,(SELECT status.name
1424: FROM cs_incident_statuses_tl status
1425: WHERE status.incident_status_id = sr.incident_status_id
1426: AND status.language = userenv(''LANG'') )Incident_Status
1427: ,(SELECT sev.name
1428: FROM cs_incident_severities_tl sev