APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_SR_ALLOWED_STATUSES

Line 1325: FROM cs_sr_allowed_statuses

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

Line 1476: FROM cs_sr_allowed_statuses

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