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 4144: FROM ams_user_statuses_vl

4140: l_note VARCHAR2(2000);
4141:
4142: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
4143: SELECT system_status_code
4144: FROM ams_user_statuses_vl
4145: WHERE user_status_id = l_user_stat_id ;
4146:
4147: BEGIN
4148: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4564: FROM ams_user_statuses_vl

4560: l_note VARCHAR2(2000);
4561:
4562: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
4563: SELECT system_status_code
4564: FROM ams_user_statuses_vl
4565: WHERE user_status_id = l_user_stat_id ;
4566:
4567: BEGIN
4568: IF (AMS_DEBUG_HIGH_ON) THEN

Line 4932: FROM ams_user_statuses_vl

4928: l_note VARCHAR2(2000);
4929:
4930: CURSOR c_sys_stat(l_user_stat_id NUMBER) IS
4931: SELECT system_status_code
4932: FROM ams_user_statuses_vl
4933: WHERE user_status_id = l_user_stat_id ;
4934:
4935: BEGIN
4936: IF (AMS_DEBUG_HIGH_ON) THEN