APPS.OZF_SD_REQUEST_PUB dependencies on DUAL

Line 2148: FROM dual;

2144: l_root_request_header_id NUMBER;
2145:
2146: CURSOR c_reqest_header_seq IS
2147: SELECT OZF_SD_REQUEST_HEADERS_ALL_B_S.nextval
2148: FROM dual;
2149:
2150: CURSOR c_code_prefix(p_request_type_setup_id IN NUMBER) IS
2151: SELECT source_code_suffix
2152: FROM ams_custom_setups_vl

Line 2379: FROM dual;

2375:
2376:
2377: CURSOR c_reqest_lines_seq IS
2378: SELECT ozf_sd_request_lines_all_s.nextval
2379: FROM dual;
2380:
2381: BEGIN
2382: -- Initialize API return status to sucess
2383: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2559: FROM dual;

2555: l_cust_count NUMBER;
2556:
2557: CURSOR c_reqest_cust_seq IS
2558: SELECT OZF_SD_CUSTOMER_DETAILS_S.nextval
2559: FROM dual;
2560:
2561: CURSOR c_cust_details(p_request_header_id IN NUMBER
2562: ,p_cust_usage_code IN VARCHAR2
2563: ,p_party_id IN NUMBER