APPS.OZF_SD_UTIL_PVT dependencies on AMS_USER_STATUSES_VL

Line 325: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS

321: END IF ;
322:
323:
324: Select REQ.request_header_id,STATUS.SYSTEM_STATUS_CODE,REQ.request_currency_code into l_req_id,l_req_status,l_curr_code
325: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS
326: where REQ.REQUEST_NUMBER = p_request_number
327: AND REQ.USER_STATUS_ID=STATUS.USER_STATUS_ID ;
328:
329:

Line 458: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl

454: AND VENDOR_APPROVED_FLAG = 'Y' ;
455:
456:
457: IF l_approved_lines > 0 THEN
458: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl
459: where system_status_TYPE='OZF_SD_REQUEST_STATUS'
460: and SYSTEM_STATUS_CODE='SUPPLIER_APPROVED'
461: and default_flag='Y'
462: and enabled_flag='Y' ;

Line 464: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl

460: and SYSTEM_STATUS_CODE='SUPPLIER_APPROVED'
461: and default_flag='Y'
462: and enabled_flag='Y' ;
463: ELSE
464: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl
465: where system_status_TYPE='OZF_SD_REQUEST_STATUS'
466: and SYSTEM_STATUS_CODE='SUPPLIER_REJECTED'
467: and default_flag='Y'
468: and enabled_flag='Y' ;