APPS.OZF_SD_REQUEST_PUB dependencies on AMS_USER_STATUSES_B

Line 196: FROM ams_user_statuses_b

192: l_user_status_id NUMBER;
193:
194: CURSOR c_user_status_id IS
195: SELECT user_status_id
196: FROM ams_user_statuses_b
197: WHERE system_status_type ='OZF_SD_REQUEST_STATUS'
198: AND enabled_flag ='Y'
199: AND default_flag ='Y'
200: AND system_status_code = p_system_status_code;

Line 228: FROM ams_user_statuses_b

224: l_system_status_code VARCHAR2(30);
225:
226: CURSOR c_system_status_code IS
227: SELECT system_status_code
228: FROM ams_user_statuses_b
229: WHERE system_status_type ='OZF_SD_REQUEST_STATUS'
230: AND enabled_flag ='Y'
231: AND user_status_id = p_user_status_id ;
232:

Line 503: FROM ams_user_statuses_b

499: WHERE request_number =p_request_number;
500:
501: CURSOR c_system_status_code(p_user_status_id IN VARCHAR2)IS
502: SELECT system_status_code
503: FROM ams_user_statuses_b
504: WHERE system_status_type ='OZF_SD_REQUEST_STATUS'
505: AND user_status_id = p_user_status_id;
506:
507: CURSOR c_order_no(p_internal_order_number IN NUMBER,p_org_id IN NUMBER)IS