APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_SR_ALLOWED_STATUSES

Line 1323: FROM cs_sr_allowed_statuses

1319:
1320: -- Check Status is allowed for the Group
1321: CURSOR allowed_Statuses_csr IS
1322: SELECT incident_status_id
1323: FROM cs_sr_allowed_statuses
1324: WHERE status_Group_id = l_status_group_id
1325: AND incident_Status_id = p_status_id
1326: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date, SYSDATE))
1327: AND TRUNC(NVL(end_date, SYSDATE));

Line 1474: FROM cs_sr_allowed_statuses

1470:
1471: -- Check Status is allowed for the Group
1472: CURSOR allowed_Statuses_csr ( p_status_group_id IN NUMBER) IS
1473: SELECT incident_status_id
1474: FROM cs_sr_allowed_statuses
1475: WHERE status_Group_id = p_status_group_id
1476: AND incident_Status_id = p_new_status_id
1477: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date, SYSDATE))
1478: AND TRUNC(NVL(end_date, SYSDATE));