APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_TYPES_B

Line 20: FROM cs_incident_types_b

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

Line 1055: cs_incident_types_b typesb

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

Line 1421: FROM cs_incident_types_b type

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
1422: WHERE type.incident_type_id = sr.incident_type_id) Detailed_Erecord
1423: ,(SELECT status.name
1424: FROM cs_incident_statuses_tl status
1425: WHERE status.incident_status_id = sr.incident_status_id