APPS.AMS_DELIVERABLE_PVT dependencies on AMS_USER_STATUSES_B

Line 253: FROM ams_user_statuses_b a

249: /*
250: CURSOR c_get_status_id(status_code IN VARCHAR2) IS
251: SELECT user_status_id
252: -- SQLID: 11753160 fix FROM ams_user_statuses_vl a
253: FROM ams_user_statuses_b a
254: WHERE system_status_type = 'AMS_DELIV_STATUS'
255: AND system_Status_code = status_code
256: AND a.user_status_id = (SELECT MIN(b.user_status_id)
257: --SQLID: 11753160 fix FROM ams_user_statuses_vl b

Line 258: FROM ams_user_statuses_b b

254: WHERE system_status_type = 'AMS_DELIV_STATUS'
255: AND system_Status_code = status_code
256: AND a.user_status_id = (SELECT MIN(b.user_status_id)
257: --SQLID: 11753160 fix FROM ams_user_statuses_vl b
258: FROM ams_user_statuses_b b
259: WHERE b.system_status_type = a.system_status_type
260: AND a.system_status_code = b.system_Status_code) ;
261: */
262:

Line 268: FROM ams_user_statuses_b a

264: -- refer bug 4956974
265: -- still not sure why MIN is being used instead of default flag = 'Y' : open issue
266: CURSOR c_get_status_id(status_code IN VARCHAR2) IS
267: SELECT min(user_status_id)
268: FROM ams_user_statuses_b a
269: WHERE system_status_type = 'AMS_DELIV_STATUS'
270: AND system_Status_code = status_code;
271:
272: