APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_TYPES_B

Line 21: FROM cs_incident_types_b

17: -- Cursors
18:
19: CURSOR get_det_erec_flag IS
20: SELECT NVL(detailed_erecord_req_flag ,'N')
21: FROM cs_incident_types_b
22: WHERE incident_type_id = p_incident_type_id ;
23:
24: -- Local variables
25: l_det_erec_req VARCHAR2(3);

Line 1126: cs_incident_types_b typesb

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');
1130:

Line 1497: FROM cs_incident_types_b type

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
1498: WHERE type.incident_type_id = sr.incident_type_id) Detailed_Erecord
1499: ,(SELECT status.name
1500: FROM cs_incident_statuses_tl status
1501: WHERE status.incident_status_id = sr.incident_status_id