DBA Data[Home] [Help]

APPS.AMS_COPYACTIVITIES_PVT dependencies on AMS_USER_STATUSES_B

Line 2190: FROM ams_user_statuses_b

2186: WHERE campaign_id = p_src_camp_id;
2187:
2188: CURSOR cur_get_default_status IS
2189: SELECT user_status_id
2190: FROM ams_user_statuses_b
2191: WHERE system_status_code = 'NEW'
2192: AND enabled_flag = 'Y'
2193: AND sysdate between start_date_active AND NVL(end_date_active,sysdate)
2194: AND default_flag = 'Y'