APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_SR_TYPE_MAPPING

Line 988: FROM cs_sr_type_mapping

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

Line 1089: from cs_sr_type_mapping

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

Line 1317: FROM cs_sr_type_mapping

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

Line 1467: FROM cs_sr_type_mapping

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