DBA Data[Home] [Help]

APPS.AMS_TCOP_UTIL_PKG dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 49: ams_campaign_schedules_b schedule

45: cursor c_get_rule(p_schedule_id number)
46: is
47: select rule_id
48: from ams_tcop_fr_rules_setup rule,
49: ams_campaign_schedules_b schedule
50: where rule.ENABLED_FLAG = 'Y'
51: and (rule.CHANNEL_ID is null
52: or (rule.CHANNEL_ID = schedule.ACTIVITY_ID) )
53: and rule.RULE_TYPE in ('GLOBAL' , 'CHANNEL_BASED')