APPS.AMS_LISTGENERATION_PKG dependencies on AMS_ACT_LISTS

Line 673: ams_act_lists t

669: a.rank,
670: sum(decode(e.marked_as_duplicate_flag,'Y',1,0))
671: FROM ams_list_entries e,
672: ams_list_select_actions a,
673: ams_act_lists t
674: WHERE e.list_header_id = p_list_header_id
675: AND e.list_select_action_id = t.act_list_header_id
676: and t.list_header_id = a.INCL_OBJECT_ID
677: AND a.arc_action_used_by = 'LIST'

Line 4759: select 'Y' from ams_act_lists where list_header_id = p_list_header_id;

4755:
4756: procedure update_list_entries(p_list_header_id in number) is
4757: l_tg_check varchar2(1) := null;
4758: cursor c_check_tg is
4759: select 'Y' from ams_act_lists where list_header_id = p_list_header_id;
4760:
4761: begin
4762: open c_check_tg;
4763: fetch c_check_tg into l_tg_check;

Line 5465: ams_act_lists als

5461: ail.CUSTOM_COLUMN23,
5462: ail.CUSTOM_COLUMN24,
5463: ail.CUSTOM_COLUMN25
5464: from ams_list_entries ail,
5465: ams_act_lists als
5466: where als.ACT_LIST_HEADER_ID = ale.list_select_action_id
5467: and als.LIST_HEADER_ID = ail.list_header_id
5468: and ail.list_entry_source_system_id = ale.list_entry_source_system_id
5469: and ail.enabled_flag = 'Y'

Line 5475: ams_act_lists als

5471: where arc_list_select_action_from = 'LIST'
5472: and list_header_id = p_list_header_id
5473: and exists (select 'x'
5474: from ams_list_entries ail,
5475: ams_act_lists als
5476: where als.ACT_LIST_HEADER_ID = ale.list_select_action_id
5477: and als.LIST_HEADER_ID = ail.list_header_id
5478: and ail.list_entry_source_system_id = ale.list_entry_source_system_id
5479: and ail.enabled_flag = 'Y' )

Line 5481: from ams_act_lists als1

5477: and als.LIST_HEADER_ID = ail.list_header_id
5478: and ail.list_entry_source_system_id = ale.list_entry_source_system_id
5479: and ail.enabled_flag = 'Y' )
5480: and exists (select 'x'
5481: from ams_act_lists als1
5482: where als1.ACT_LIST_HEADER_ID = ale.list_select_action_id
5483: and als1.LIST_ACTION_TYPE = 'INCLUDE' );
5484: write_to_act_log(sql%rowcount||' entries updated.','LIST',g_list_header_id,'LOW');
5485:

Line 8729: FROM ams_act_lists a ,ams_act_lists b, ams_list_select_actions c

8725: -- a.act_list_header_id,
8726: c.list_select_action_id act_list_header_id,
8727: c.distribution_pct distribution_pct,
8728: c.arc_incl_object_from arc_incl_object_from
8729: FROM ams_act_lists a ,ams_act_lists b, ams_list_select_actions c
8730: WHERE a.list_used_by_id = b.list_used_by_id
8731: AND a.list_used_by = b.list_used_by
8732: AND b.list_header_id = p_action_used_by_id
8733: AND b.list_act_type = 'TARGET'

Line 8827: FROM ams_act_lists a ,ams_act_lists b

8823: l_incl_header_id number;
8824:
8825: CURSOR c_repeat_tg_id is
8826: SELECT a.list_header_id
8827: FROM ams_act_lists a ,ams_act_lists b
8828: WHERE a.list_used_by_id = b.list_used_by_id
8829: AND a.list_used_by = b.list_used_by
8830: AND b.list_header_id = g_list_header_id
8831: AND b.list_act_type = 'TARGET'

Line 13999: from ams_act_lists

13995: and rownum = 1;
13996:
13997: cursor c_get_list_used_by_id is
13998: select list_used_by_id
13999: from ams_act_lists
14000: where list_header_id = p_list_header_id
14001: and list_used_by = 'CSCH'
14002: and list_act_type = 'TARGET';
14003:

Line 14012: from ams_act_lists

14008: and arc_incl_object_from = 'EMPLOYEE';
14009:
14010: cursor c4(l_list_used_by_id number) is
14011: select 1
14012: from ams_act_lists
14013: where list_used_by_id = l_list_used_by_id
14014: and list_act_type = 'EMPLOYEE';
14015:
14016: l_list_type varchar2(100) := null;