DBA Data[Home] [Help]

APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_ACT_ACCESS

Line 3101: FROM ams_act_access

3097: WHERE campaign_id = p_campaign_id;
3098:
3099: CURSOR c_access_csch_det(p_schedule_id NUMBER, p_owner NUMBER) IS
3100: SELECT *
3101: FROM ams_act_access
3102: WHERE arc_act_access_to_object = 'CSCH'
3103: AND user_or_role_id = p_owner
3104: AND arc_user_or_role_type = 'USER'
3105: AND act_access_to_object_id = p_schedule_id;