APPS.AMS_TRACKING_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 208: select distinct owner_user_id, activity_id, activity_type_code into l_resource_id, l_activity_id, l_activity_type from AMS_CAMPAIGN_SCHEDULES_B csched

204: -- insert_log_mesg('obj_type from src_codes tbl::' || obj_type);
205:
206: IF (obj_type = 'CSCH')
207: THEN
208: select distinct owner_user_id, activity_id, activity_type_code into l_resource_id, l_activity_id, l_activity_type from AMS_CAMPAIGN_SCHEDULES_B csched
209: where (csched.source_code=p_track_rec.obj_src_code);
210:
211: ELSIF ( (obj_type = 'EONE') OR (obj_type = 'EVEO') )
212: THEN