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 4752: select 'Y' from ams_act_lists where list_header_id = p_list_header_id;

4748:
4749: procedure update_list_entries(p_list_header_id in number) is
4750: l_tg_check varchar2(1) := null;
4751: cursor c_check_tg is
4752: select 'Y' from ams_act_lists where list_header_id = p_list_header_id;
4753:
4754: begin
4755: open c_check_tg;
4756: fetch c_check_tg into l_tg_check;

Line 5458: ams_act_lists als

5454: ail.CUSTOM_COLUMN23,
5455: ail.CUSTOM_COLUMN24,
5456: ail.CUSTOM_COLUMN25
5457: from ams_list_entries ail,
5458: ams_act_lists als
5459: where als.ACT_LIST_HEADER_ID = ale.list_select_action_id
5460: and als.LIST_HEADER_ID = ail.list_header_id
5461: and ail.list_entry_source_system_id = ale.list_entry_source_system_id
5462: and ail.enabled_flag = 'Y'

Line 5468: ams_act_lists als

5464: where arc_list_select_action_from = 'LIST'
5465: and list_header_id = p_list_header_id
5466: and exists (select 'x'
5467: from ams_list_entries ail,
5468: ams_act_lists als
5469: where als.ACT_LIST_HEADER_ID = ale.list_select_action_id
5470: and als.LIST_HEADER_ID = ail.list_header_id
5471: and ail.list_entry_source_system_id = ale.list_entry_source_system_id
5472: and ail.enabled_flag = 'Y' )

Line 5474: from ams_act_lists als1

5470: and als.LIST_HEADER_ID = ail.list_header_id
5471: and ail.list_entry_source_system_id = ale.list_entry_source_system_id
5472: and ail.enabled_flag = 'Y' )
5473: and exists (select 'x'
5474: from ams_act_lists als1
5475: where als1.ACT_LIST_HEADER_ID = ale.list_select_action_id
5476: and als1.LIST_ACTION_TYPE = 'INCLUDE' );
5477: write_to_act_log(sql%rowcount||' entries updated.','LIST',g_list_header_id,'LOW');
5478:

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

8637: -- a.act_list_header_id,
8638: c.list_select_action_id act_list_header_id,
8639: c.distribution_pct distribution_pct,
8640: c.arc_incl_object_from arc_incl_object_from
8641: FROM ams_act_lists a ,ams_act_lists b, ams_list_select_actions c
8642: WHERE a.list_used_by_id = b.list_used_by_id
8643: AND a.list_used_by = b.list_used_by
8644: AND b.list_header_id = p_action_used_by_id
8645: AND b.list_act_type = 'TARGET'

Line 8732: FROM ams_act_lists a ,ams_act_lists b

8728: l_incl_header_id number;
8729:
8730: CURSOR c_repeat_tg_id is
8731: SELECT a.list_header_id
8732: FROM ams_act_lists a ,ams_act_lists b
8733: WHERE a.list_used_by_id = b.list_used_by_id
8734: AND a.list_used_by = b.list_used_by
8735: AND b.list_header_id = g_list_header_id
8736: AND b.list_act_type = 'TARGET'

Line 13898: from ams_act_lists

13894: and rownum = 1;
13895:
13896: cursor c_get_list_used_by_id is
13897: select list_used_by_id
13898: from ams_act_lists
13899: where list_header_id = p_list_header_id
13900: and list_used_by = 'CSCH'
13901: and list_act_type = 'TARGET';
13902:

Line 13911: from ams_act_lists

13907: and arc_incl_object_from = 'EMPLOYEE';
13908:
13909: cursor c4(l_list_used_by_id number) is
13910: select 1
13911: from ams_act_lists
13912: where list_used_by_id = l_list_used_by_id
13913: and list_act_type = 'EMPLOYEE';
13914:
13915: l_list_type varchar2(100) := null;