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

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