56:
57: /* Following code is added by rrajesh on 09/12/01 */
58: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS
59: SELECT *
60: FROM ams_campaign_schedules_vl
61: WHERE campaign_id = l_camp_id;
62:
63: l_schedule_rec c_access_camp_schedules%ROWTYPE;
64: /* end change 09/12/01 */
457:
458: /* Following code is added by rrajesh on 09/12/01 */
459: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS
460: SELECT *
461: FROM ams_campaign_schedules_vl
462: WHERE campaign_id = l_camp_id;
463:
464: /* commented by skarumur, using c_getobj_type_id cursor
465: CURSOR c_get_camp_id(l_activity_access_id IN NUMBER) IS
941: /* Following code is added by rrajesh on 09/12/01 */
942:
943: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS
944: SELECT *
945: FROM ams_campaign_schedules_vl
946: WHERE campaign_id = l_camp_id;
947:
948: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
949: SELECT arc_user_or_role_type