APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_NUMBER_S

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

13781: END IF;
13782:
13783: IF l_request_number IS NULL THEN
13784: LOOP
13785: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;
13786: BEGIN
13787: SELECT incident_number INTO l_temp_num FROM cs_incidents_all_b
13788: WHERE incident_number = x_req_num;
13789: EXCEPTION