DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_URGENCIES_TL

Line 1090: FROM cs_incident_urgencies_tl urgency

1086:
1087: --:Incident_Urgency
1088: CURSOR Get_Inc_Urg (v_incident_urgency_id NUMBER) IS
1089: SELECT urgency.name
1090: FROM cs_incident_urgencies_tl urgency
1091: WHERE urgency.incident_urgency_id = v_incident_urgency_id
1092: AND urgency.language = userenv('LANG');
1093:
1094: l_Incident_Urgency VARCHAR2(30);

Line 1436: FROM cs_incident_urgencies_tl urgency

1432: FROM cs_incident_severities_b sev
1433: WHERE sev.incident_severity_id = sr.incident_severity_id
1434: ) Sev_Importance_Level
1435: ,(SELECT urgency.name
1436: FROM cs_incident_urgencies_tl urgency
1437: WHERE urgency.incident_urgency_id = sr.incident_urgency_id
1438: AND urgency.language = userenv(''LANG'')) Incident_Urgency
1439: ,(SELECT gr.group_name
1440: FROM jtf_rs_groups_tl gr