DBA Data[Home] [Help]

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: