DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_TYPES_TL

Line 1054: FROM cs_incident_types_tl typest,

1050: --:Detailed_Erecord
1051:
1052: CURSOR Incident_Type (v_incident_type_id NUMBER) IS
1053: SELECT typest.name, nvl(typesb.detailed_erecord_req_flag,'N') Detailed_Erecord
1054: FROM cs_incident_types_tl typest,
1055: cs_incident_types_b typesb
1056: WHERE typesb.incident_type_id = v_incident_type_id
1057: AND typesb.incident_type_id = typest.incident_type_id
1058: AND typest.language = userenv('LANG');

Line 1417: FROM cs_incident_types_tl type

1413:
1414: l_query := 'SELECT
1415: sr.incident_number Incident_Number
1416: ,(SELECT type.name
1417: FROM cs_incident_types_tl type
1418: WHERE type.incident_type_id = sr.incident_type_id
1419: AND type.language = userenv(''LANG'')) Incident_Type
1420: ,(SELECT type.detailed_erecord_req_flag
1421: FROM cs_incident_types_b type