APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_USER_STATUSES_B

Line 64: FROM ams_user_statuses_b

60: l_status_code VARCHAR2(30);
61:
62: CURSOR c_status_code IS
63: SELECT system_status_code
64: FROM ams_user_statuses_b
65: WHERE user_status_id = p_user_status_id
66: -- Commented by ptendulk on 07-May-2001 as Program and campaign use the same api.
67: -- AND system_status_type = 'AMS_CAMPAIGN_STATUS'
68: AND enabled_flag = 'Y';