APPS.AMS_WFCMPAPR_PVT dependencies on AMS_USER_STATUSES_VL

Line 1185: FROM ams_user_statuses_vl

1181: CURSOR c_next_user_status(l_stat_type IN VARCHAR2,
1182: l_stat_code IN VARCHAR2)
1183: IS
1184: SELECT user_status_id
1185: FROM ams_user_statuses_vl
1186: WHERE system_status_code = l_stat_code
1187: AND system_status_type = l_stat_type
1188: AND default_flag = 'Y' ;
1189:

Line 1528: FROM ams_user_statuses_vl

1524:
1525: CURSOR c_sys_status(l_user_stat_id IN NUMBER)
1526: IS
1527: SELECT system_status_code
1528: FROM ams_user_statuses_vl
1529: WHERE user_status_id = l_user_stat_id ;
1530:
1531: CURSOR c_stat_rule(l_sys_stat_type IN VARCHAR2,
1532: l_curr_stat IN VARCHAR2,

Line 2705: FROM ams_user_statuses_vl

2701: l_return_status VARCHAR2(1);
2702:
2703: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
2704: SELECT system_status_code
2705: FROM ams_user_statuses_vl
2706: WHERE user_status_id = l_user_stat_id ;
2707:
2708: BEGIN
2709: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4172: FROM ams_user_statuses_vl

4168: l_note VARCHAR2(2000);
4169:
4170: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
4171: SELECT system_status_code
4172: FROM ams_user_statuses_vl
4173: WHERE user_status_id = l_user_stat_id ;
4174:
4175: BEGIN
4176: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4592: FROM ams_user_statuses_vl

4588: l_note VARCHAR2(2000);
4589:
4590: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
4591: SELECT system_status_code
4592: FROM ams_user_statuses_vl
4593: WHERE user_status_id = l_user_stat_id ;
4594:
4595: BEGIN
4596: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4960: FROM ams_user_statuses_vl

4956: l_note VARCHAR2(2000);
4957:
4958: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
4959: SELECT system_status_code
4960: FROM ams_user_statuses_vl
4961: WHERE user_status_id = l_user_stat_id ;
4962:
4963: BEGIN
4964: IF (AMS_DEBUG_HIGH_ON) THEN