APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_TYPES_B

Line 996: FROM cs_incident_types_b

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

Line 1099: from cs_incident_types_b

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

Line 1311: FROM cs_incident_types_B

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

Line 1459: FROM cs_incident_types_B

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

Line 7471: from cs_incident_types_b

7467: if ( l_cont_srv_id IS NOT NULL and l_cont_srv_id <> FND_API.G_MISS_NUM ) then
7468: begin
7469: select business_process_id
7470: into l_busi_proc_id
7471: from cs_incident_types_b
7472: where incident_type_id = l_sr_type_id;
7473: exception
7474: when no_data_found then
7475: raise fnd_api.g_exc_unexpected_error;