APPS.AMS_LISTHEADER_PVT dependencies on AMS_USER_STATUSES_VL

Line 74: FROM ams_user_statuses_vl

70:
71: l_meaning varchar2(80);
72: CURSOR c_system_status_code is
73: SELECT system_status_code
74: FROM ams_user_statuses_vl
75: WHERE user_status_id = p_user_status_id ;
76: BEGIN
77: -- Initialize API/Procedure return status to success
78: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1228: FROM ams_user_statuses_vl

1224: ;
1225:
1226: CURSOR c_default_list_user_status_id IS
1227: SELECT user_status_id
1228: FROM ams_user_statuses_vl
1229: WHERE system_status_type = 'AMS_LIST_STATUS'
1230: AND system_status_code = 'DRAFT'
1231: AND enabled_flag = 'Y'
1232: AND default_flag = 'Y';