APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_NUMBER_S

Line 14921: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;

14917: END IF;
14918:
14919: IF l_request_number IS NULL THEN
14920: LOOP
14921: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;
14922: BEGIN
14923: SELECT incident_number INTO l_temp_num FROM cs_incidents_all_b
14924: WHERE incident_number = x_req_num;
14925: EXCEPTION