DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_URGENCIES_TL

Line 1161: FROM cs_incident_urgencies_tl urgency

1157:
1158: --:Incident_Urgency
1159: CURSOR Get_Inc_Urg (v_incident_urgency_id NUMBER) IS
1160: SELECT urgency.name
1161: FROM cs_incident_urgencies_tl urgency
1162: WHERE urgency.incident_urgency_id = v_incident_urgency_id
1163: AND urgency.language = userenv('LANG');
1164:
1165: l_Incident_Urgency VARCHAR2(30);

Line 1512: FROM cs_incident_urgencies_tl urgency

1508: FROM cs_incident_severities_b sev
1509: WHERE sev.incident_severity_id = sr.incident_severity_id
1510: ) Sev_Importance_Level
1511: ,(SELECT urgency.name
1512: FROM cs_incident_urgencies_tl urgency
1513: WHERE urgency.incident_urgency_id = sr.incident_urgency_id
1514: AND urgency.language = userenv(''LANG'')) Incident_Urgency
1515: ,(SELECT gr.group_name
1516: FROM jtf_rs_groups_tl gr