APPS.AMS_ACCESS_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 85: FROM ams_campaign_schedules_vl

81:
82: /* Following code is added by rrajesh on 09/12/01 */
83: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS
84: SELECT *
85: FROM ams_campaign_schedules_vl
86: WHERE campaign_id = l_camp_id;
87:
88: l_schedule_rec c_access_camp_schedules%ROWTYPE;
89: /* end change 09/12/01 */

Line 601: FROM ams_campaign_schedules_vl

597:
598: /* Following code is added by rrajesh on 09/12/01 */
599: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS
600: SELECT *
601: FROM ams_campaign_schedules_vl
602: WHERE campaign_id = l_camp_id;
603:
604: /* commented by skarumur, using c_getobj_type_id cursor
605: CURSOR c_get_camp_id(l_activity_access_id IN NUMBER) IS

Line 1188: FROM ams_campaign_schedules_vl

1184: /* Following code is added by rrajesh on 09/12/01 */
1185:
1186: CURSOR c_access_camp_schedules(l_camp_id IN NUMBER) IS
1187: SELECT *
1188: FROM ams_campaign_schedules_vl
1189: WHERE campaign_id = l_camp_id;
1190:
1191: CURSOR c_get_user_or_role_type(l_activity_access_id IN NUMBER) IS
1192: SELECT arc_user_or_role_type