APPS.OKL_VP_CHANGE_REQUEST_PVT dependencies on DUAL

Line 40: FROM dual;

36: FUNCTION generate_change_req_num RETURN okl_vp_change_requests.change_request_number%TYPE IS
37: -- cursor to fetch the next available change request number
38: CURSOR c_get_next_cr_num IS
39: SELECT okl_vp_change_req_num_seq.NEXTVAL
40: FROM dual;
41: lv_new_change_request_number okl_vp_change_requests.change_request_number%TYPE;
42: BEGIN
43: OPEN c_get_next_cr_num; FETCH c_get_next_cr_num INTO lv_new_change_request_number;
44: CLOSE c_get_next_cr_num;