DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_LOOKUPS

Line 6114: ams_lookups lookup

6110: campaign_id
6111: FROM ams_campaign_schedules_b csch,
6112: ams_scheduler scheduler,
6113: AMS_MEDIA_VL Med,
6114: ams_lookups lookup
6115: WHERE csch.schedule_id = p_schedule_id
6116: AND scheduler.OBJECT_ID(+) = nvl(csch.orig_csch_id, csch.schedule_id)
6117: AND scheduler.OBJECT_TYPE(+) = 'CSCH'
6118: AND Med.media_id = csch.activity_id