APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_FR_RULES_SETUP

Line 510: FROM ams_tcop_fr_rules_setup rule,

506:
507: CURSOR C_GET_RULE_DTLS(p_schedule_id NUMBER)
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

Line 531: FROM ams_tcop_fr_rules_setup

527: WHERE list.LIST_HEADER_ID = p_list_header_id
528: AND summary.PARTY_ID = list.PARTY_ID
529: AND list.ENABLED_FLAG = 'Y'
530: AND summary.total_contacts >= (SELECT max_contact_allowed
531: FROM ams_tcop_fr_rules_setup
532: WHERE rule_id =p_rule_id);
533:
534: CURSOR c_Get_Global_Fatigue_list2(p_list_header_id number,
535: p_rule_id number,

Line 546: FROM ams_tcop_fr_rules_setup

542: WHERE list.LIST_HEADER_ID = p_list_header_id
543: AND summary.PARTY_ID = list.PARTY_ID
544: AND list.ENABLED_FLAG = 'Y'
545: AND summary.total_contacts >= (SELECT max_contact_allowed
546: FROM ams_tcop_fr_rules_setup
547: WHERE rule_id =p_rule_id)
548: AND list.party_id not in
549: (SELECT column_value
550: FROM TABLE(CAST(p_already_fatigued_list as JTF_NUMBER_TABLE))

Line 566: FROM ams_tcop_fr_rules_setup

562: AND summary.PARTY_ID = list.PARTY_ID
563: AND list.ENABLED_FLAG = 'Y'
564: AND summary.media_id = p_media_id
565: AND summary.total_contacts >= (SELECT max_contact_allowed
566: FROM ams_tcop_fr_rules_setup
567: WHERE rule_id =p_rule_id);
568:
569: -- Get the list of parties already over contacted by the channel specific rule
570: -- But don't consider the list of parties already fatigued by another rule

Line 585: FROM ams_tcop_fr_rules_setup

581: AND summary.PARTY_ID = list.PARTY_ID
582: AND list.ENABLED_FLAG = 'Y'
583: AND summary.media_id = p_media_id
584: AND summary.total_contacts >= (SELECT max_contact_allowed
585: FROM ams_tcop_fr_rules_setup
586: WHERE rule_id =p_rule_id)
587: AND list.party_id not in
588: (SELECT column_value
589: FROM TABLE(CAST(p_already_fatigued_list as JTF_NUMBER_TABLE))

Line 604: FROM ams_tcop_fr_rules_setup

600: ams_tcop_contact_sum_dtl sum_dtl
601: WHERE list.LIST_HEADER_ID =
602: AND summary.PARTY_ID = list.PARTY_ID
603: AND summary.total_contacts = (SELECT max_contact_allowed
604: FROM ams_tcop_fr_rules_setup
605: WHERE rule_id = p_rule_id)
606: AND summary.CONTACT_SUMMARY_ID = sum_dtl.CONTACT_SUMMARY_ID;
607: **/
608: