APPS.AMS_LISTDEDUPE_PVT dependencies on AMS_LIST_SELECT_ACTIONS

Line 394: FROM ams_list_select_actions

390: -- checking to see if there are any List Source Ranks associated
391: -- with the List.
392: SELECT COUNT (rank)
393: INTO l_rank_count
394: FROM ams_list_select_actions
395: WHERE action_used_by_id = p_list_header_id
396: and arc_action_used_by = 'LIST';
397:
398: IF (p_send_to_log = 'Y')

Line 601: ams_list_select_actions a

597: AND dedupe_key = l_dedupe_key
598: AND list_entry_id <> ( SELECT MIN (c.list_entry_id)
599: --selecting the master.
600: FROM ams_list_entries c,
601: ams_list_select_actions a
602: WHERE c.list_header_id =
603: p_list_header_id
604: AND c.dedupe_key = l_dedupe_key
605: AND c.list_select_action_id = a.list_select_action_id);

Line 608: FROM ams_list_select_actions b

604: AND c.dedupe_key = l_dedupe_key
605: AND c.list_select_action_id = a.list_select_action_id);
606: /*
607: AND a.rank =(SELECT min(b.rank)
608: FROM ams_list_select_actions b
609: WHERE b.action_used_by_id = p_list_header_id
610: and b.arc_action_used_by = 'LIST')
611: GROUP BY a.rank); */
612: --even if there are no ranks for this sql stmt we will still