APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_TYPES_B

Line 994: FROM cs_incident_types_b

990: AND TRUNC(NVL(end_date, SYSDATE));
991:
992: CURSOR val_type IS
993: SELECT CMRO_flag,Maintenance_flag
994: FROM cs_incident_types_b
995: WHERE incident_type_id = p_type_id
996: AND incident_subtype = p_subtype
997: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
998: AND TRUNC(NVL(end_date_active, SYSDATE));

Line 1097: from cs_incident_types_b

1093:
1094: -- For bug 3474365
1095: cursor val_type_unsecure is
1096: select UPPER(cmro_flag), UPPER(maintenance_flag),start_date_active,end_date_active
1097: from cs_incident_types_b
1098: where incident_type_id = p_type_id
1099: and incident_subtype = p_subtype;
1100: -- and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
1101: -- and trunc(nvl(end_date_active, sysdate));

Line 1309: FROM cs_incident_types_B

1305: AND TRUNC(NVL(end_date_active, SYSDATE));
1306:
1307: CURSOR group_for_type_Csr IS
1308: SELECT status_Group_id
1309: FROM cs_incident_types_B
1310: WHERE Incident_type_id = p_type_id;
1311: /* Type is already validated **/
1312:
1313: CURSOR group_for_type_resp_csr IS

Line 1457: FROM cs_incident_types_B

1453: AND TRUNC(NVL(end_date_active, SYSDATE));
1454:
1455: CURSOR group_for_type_Csr (l_type_id IN NUMBER) IS
1456: SELECT status_Group_id
1457: FROM cs_incident_types_B
1458: WHERE Incident_type_id = l_type_id
1459: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1460: AND TRUNC(NVL(end_date_active, SYSDATE));
1461: /* Type is already validated **/

Line 7455: from cs_incident_types_b

7451: if ( l_cont_srv_id IS NOT NULL and l_cont_srv_id <> FND_API.G_MISS_NUM ) then
7452: begin
7453: select business_process_id
7454: into l_busi_proc_id
7455: from cs_incident_types_b
7456: where incident_type_id = l_sr_type_id;
7457: exception
7458: when no_data_found then
7459: raise fnd_api.g_exc_unexpected_error;