APPS.AMS_ADI_CAMP_SCHED_PVT dependencies on AMS_USER_STATUSES_VL

Line 166: from ams_user_statuses_vl

162: -- Initialize API return status to SUCCESS
163: l_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: select user_status_id into l_avail_default_user_status
166: from ams_user_statuses_vl
167: where system_status_type = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
168: and system_status_code = 'AVAILABLE'
169: and default_flag = 'Y';
170: