APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_ACT_ACCESS

Line 2538: FROM ams_act_access

2534: IS
2535:
2536: CURSOR c_access_det IS
2537: SELECT *
2538: FROM ams_act_access
2539: WHERE arc_act_access_to_object = 'CAMP'
2540: AND act_access_to_object_id = p_campaign_id ;
2541: l_access_det c_access_det%ROWTYPE;
2542:

Line 3233: FROM ams_act_access

3229: WHERE schedule_id = p_schedule_id ;
3230:
3231: CURSOR c_access_csch_det(p_owner NUMBER) IS
3232: SELECT *
3233: FROM ams_act_access
3234: WHERE arc_act_access_to_object = 'CSCH'
3235: AND user_or_role_id = p_owner
3236: AND arc_user_or_role_type = 'USER'
3237: AND act_access_to_object_id = p_schedule_id;

Line 3241: FROM ams_act_access

3237: AND act_access_to_object_id = p_schedule_id;
3238:
3239: CURSOR c_access_camp_det(p_campaign_id NUMBER) IS
3240: SELECT *
3241: FROM ams_act_access
3242: WHERE arc_act_access_to_object = 'CAMP'
3243: -- AND user_or_role_id = p_owner_id
3244: AND arc_user_or_role_type = 'USER'
3245: AND act_access_to_object_id = p_campaign_id;