APPS.OZF_SD_UTIL_PVT dependencies on AMS_USER_STATUSES_VL

Line 444: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS

440: END IF ;
441:
442:
443: Select REQ.request_header_id,STATUS.SYSTEM_STATUS_CODE,REQ.request_currency_code into l_req_id,l_req_status,l_curr_code
444: from OZF_SD_REQUEST_HEADERS_ALL_B REQ,AMS_USER_STATUSES_VL STATUS
445: where REQ.REQUEST_NUMBER = p_request_number
446: AND REQ.USER_STATUS_ID=STATUS.USER_STATUS_ID ;
447:
448:

Line 577: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl

573: AND VENDOR_APPROVED_FLAG = 'Y' ;
574:
575:
576: IF l_approved_lines > 0 THEN
577: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl
578: where system_status_TYPE='OZF_SD_REQUEST_STATUS'
579: and SYSTEM_STATUS_CODE='SUPPLIER_APPROVED'
580: and default_flag='Y'
581: and enabled_flag='Y' ;

Line 583: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl

579: and SYSTEM_STATUS_CODE='SUPPLIER_APPROVED'
580: and default_flag='Y'
581: and enabled_flag='Y' ;
582: ELSE
583: SELECT user_status_id INTO l_request_status FROM ams_user_statuses_vl
584: where system_status_TYPE='OZF_SD_REQUEST_STATUS'
585: and SYSTEM_STATUS_CODE='SUPPLIER_REJECTED'
586: and default_flag='Y'
587: and enabled_flag='Y' ;