APPS.IEC_STATUS_PVT dependencies on AMS_USER_STATUSES_B
Line 969: FROM AMS_USER_STATUSES_B
965: BEGIN
966:
967: SELECT USER_STATUS_ID
968: INTO l_user_status_id 969: FROM AMS_USER_STATUSES_B 970: WHERE SYSTEM_STATUS_TYPE = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
971: AND SYSTEM_STATUS_CODE = 'ON_HOLD'
972: AND ROWNUM = 1;
973: