DBA Data[Home] [Help]

APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_FR_PERIODS_B

Line 512: ams_tcop_fr_periods_b period

508: IS
509: SELECT rule_id,rule_type
510: FROM ams_tcop_fr_rules_setup rule,
511: ams_campaign_schedules_b schedule,
512: ams_tcop_fr_periods_b period
513: WHERE rule.ENABLED_FLAG = 'Y'
514: AND (rule.CHANNEL_ID is null
515: OR (rule.CHANNEL_ID = schedule.activity_id) )
516: AND rule.RULE_TYPE in ('GLOBAL' , 'CHANNEL_BASED')