APPS.AMS_DELIVERABLE_PVT dependencies on AMS_USER_STATUSES_VL

Line 241: FROM ams_user_statuses_vl

237: WHERE deliverable_id = deliv_id;
238:
239: CURSOR c_status_code(status_id IN NUMBER) IS
240: SELECT system_status_code
241: FROM ams_user_statuses_vl
242: WHERE system_status_type = 'AMS_DELIV_STATUS'
243: AND user_status_id = status_id;
244:
245: CURSOR c_get_custom_setup_id IS

Line 252: -- SQLID: 11753160 fix FROM ams_user_statuses_vl a

248: WHERE object_type = 'DELV';
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)

Line 257: --SQLID: 11753160 fix FROM ams_user_statuses_vl b

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
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: */

Line 1287: FROM ams_user_statuses_vl

1283: l_workflowprocess VARCHAR2(30) := 'AMS_APPROVAL';
1284:
1285: CURSOR c_new_status_code(status_id IN NUMBER) IS
1286: SELECT system_status_code
1287: FROM ams_user_statuses_vl
1288: WHERE user_status_id = status_id;
1289:
1290: CURSOR c_user_status_id (p_status_code IN VARCHAR2) IS
1291: SELECT user_status_id

Line 1292: FROM ams_user_statuses_vl

1288: WHERE user_status_id = status_id;
1289:
1290: CURSOR c_user_status_id (p_status_code IN VARCHAR2) IS
1291: SELECT user_status_id
1292: FROM ams_user_statuses_vl
1293: WHERE system_status_type = l_deliv_status_type
1294: AND system_status_code = p_status_code
1295: AND default_flag = 'Y';
1296: