596: IS
597: SELECT list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
598: FROM ams_tcop_contact_summary summary,
599: ams_list_entries list,
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
620: SELECT /*+ leading(party_list) +*/
621: list.LIST_ENTRY_ID,sum_dtl.SCHEDULE_ID
622: FROM ams_tcop_contact_summary summary,
623: ams_list_entries list,
624: ams_tcop_contact_sum_dtl sum_dtl,
625: (SELECT column_value party_id
626: FROM TABLE(CAST(p_ftg_party_list as JTF_NUMBER_TABLE))
627: ) party_list
628: WHERE summary.CONTACT_SUMMARY_ID = sum_dtl.CONTACT_SUMMARY_ID