APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_SR_TYPE_MAPPING

Line 986: FROM cs_sr_type_mapping

982: l_profile VARCHAR2(9);
983:
984: CURSOR val_type_map IS
985: SELECT 'x'
986: FROM cs_sr_type_mapping
987: WHERE incident_type_id = p_type_id
988: AND responsibility_id = p_resp_id
989: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date, SYSDATE))
990: AND TRUNC(NVL(end_date, SYSDATE));

Line 1087: from cs_sr_type_mapping

1083: l_end_date DATE;
1084:
1085: cursor val_type_map is
1086: select 'x'
1087: from cs_sr_type_mapping
1088: where incident_type_id = p_type_id
1089: and responsibility_id = p_resp_id
1090: and application_id = p_resp_appl_id -- new for 11.5.10
1091: and trunc(sysdate) between trunc(nvl(start_date, sysdate))

Line 1315: FROM cs_sr_type_mapping

1311: /* Type is already validated **/
1312:
1313: CURSOR group_for_type_resp_csr IS
1314: SELECT status_Group_id
1315: FROM cs_sr_type_mapping
1316: WHERE Incident_type_id = p_type_id
1317: AND responsibility_id = p_resp_id
1318: AND status_group_id IS NOT NULL;
1319:

Line 1465: FROM cs_sr_type_mapping

1461: /* Type is already validated **/
1462:
1463: CURSOR group_for_type_resp_csr (l_type_id IN NUMBER, l_resp_id IN NUMBER) IS
1464: SELECT status_Group_id
1465: FROM cs_sr_type_mapping
1466: WHERE Incident_type_id = l_type_id
1467: AND responsibility_id = l_resp_id
1468: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date, SYSDATE))
1469: AND TRUNC(NVL(end_date, SYSDATE)) ;