APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_ACT_ACCESS

Line 2526: FROM ams_act_access

2522: IS
2523:
2524: CURSOR c_access_det IS
2525: SELECT *
2526: FROM ams_act_access
2527: WHERE arc_act_access_to_object = 'CAMP'
2528: AND act_access_to_object_id = p_campaign_id ;
2529: l_access_det c_access_det%ROWTYPE;
2530:

Line 3221: FROM ams_act_access

3217: WHERE schedule_id = p_schedule_id ;
3218:
3219: CURSOR c_access_csch_det(p_owner NUMBER) IS
3220: SELECT *
3221: FROM ams_act_access
3222: WHERE arc_act_access_to_object = 'CSCH'
3223: AND user_or_role_id = p_owner
3224: AND arc_user_or_role_type = 'USER'
3225: AND act_access_to_object_id = p_schedule_id;

Line 3229: FROM ams_act_access

3225: AND act_access_to_object_id = p_schedule_id;
3226:
3227: CURSOR c_access_camp_det(p_campaign_id NUMBER) IS
3228: SELECT *
3229: FROM ams_act_access
3230: WHERE arc_act_access_to_object = 'CAMP'
3231: -- AND user_or_role_id = p_owner_id
3232: AND arc_user_or_role_type = 'USER'
3233: AND act_access_to_object_id = p_campaign_id;