APPS.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_FR_PERIODS_B

Line 482: ams_tcop_fr_periods_b period

478: ,rule.rule_type rule_type
479: ,period.no_of_days no_of_days
480: ,rule.max_contact_allowed max_contact_allowed
481: FROM ams_tcop_fr_rules_setup rule,
482: ams_tcop_fr_periods_b period
483: WHERE rule.ENABLED_FLAG = 'Y'
484: AND (rule.CHANNEL_ID is null
485: OR (rule.CHANNEL_ID = p_activity_id) )
486: AND rule.RULE_TYPE in ('GLOBAL' , 'CHANNEL_BASED')

Line 2222: FROM AMS_TCOP_FR_PERIODS_B PERIOD,

2218: IS
2219: SELECT RULE.RULE_TYPE RULE_TYPE,
2220: RULE.MAX_CONTACT_ALLOWED MAX_CONTACT_ALLOWED,
2221: PERIOD.NO_OF_DAYS NO_OF_DAYS
2222: FROM AMS_TCOP_FR_PERIODS_B PERIOD,
2223: AMS_TCOP_FR_RULES_SETUP RULE
2224: WHERE RULE.PERIOD_ID = PERIOD.PERIOD_ID
2225: AND (RULE.CHANNEL_ID IS NULL OR RULE.CHANNEL_ID = p_activity_id);
2226: