DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_TYPES_TL

Line 1125: FROM cs_incident_types_tl typest,

1121: --:Detailed_Erecord
1122:
1123: CURSOR Incident_Type (v_incident_type_id NUMBER) IS
1124: SELECT typest.name, nvl(typesb.detailed_erecord_req_flag,'N') Detailed_Erecord
1125: FROM cs_incident_types_tl typest,
1126: cs_incident_types_b typesb
1127: WHERE typesb.incident_type_id = v_incident_type_id
1128: AND typesb.incident_type_id = typest.incident_type_id
1129: AND typest.language = userenv('LANG');

Line 1493: FROM cs_incident_types_tl type

1489:
1490: l_query := 'SELECT
1491: sr.incident_number Incident_Number
1492: ,(SELECT type.name
1493: FROM cs_incident_types_tl type
1494: WHERE type.incident_type_id = sr.incident_type_id
1495: AND type.language = userenv(''LANG'')) Incident_Type
1496: ,(SELECT type.detailed_erecord_req_flag
1497: FROM cs_incident_types_b type