APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_RULES_ALL

Line 6885: FROM ams_list_rule_usages us, ams_list_rules_all rules

6881: WHERE list_header_id = g_list_header_id;*/
6882:
6883: CURSOR C1 IS
6884: SELECT us.list_rule_id
6885: FROM ams_list_rule_usages us, ams_list_rules_all rules
6886: WHERE us.list_header_id = g_list_header_id
6887: AND us.list_rule_id = rules.list_rule_id
6888: AND rules.list_source_type = l_listheader_rec.list_source_type
6889: AND rules.list_rule_type = 'TARGET';

Line 9564: FROM ams_list_rule_usages us, ams_list_rules_all rules

9560: WHERE list_header_id = g_list_header_id;*/
9561:
9562: CURSOR C1 IS
9563: SELECT us.list_rule_id
9564: FROM ams_list_rule_usages us, ams_list_rules_all rules
9565: WHERE us.list_header_id = g_list_header_id
9566: AND us.list_rule_id = rules.list_rule_id
9567: AND rules.list_source_type = l_listheader_rec.list_source_type
9568: AND rules.list_rule_type = 'TARGET';

Line 10486: ams_list_rules_all.list_rule_id%TYPE)

10482:
10483: -- the list of fields for the list rule which are used to generate the key.
10484: CURSOR c_rule_fields
10485: (my_list_rule_id IN
10486: ams_list_rules_all.list_rule_id%TYPE)
10487: IS
10488: SELECT field_table_name,
10489: field_column_name,
10490: substring_length,

Line 10526: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;

10522: l_sql_stmt2 VARCHAR2(10000);
10523:
10524: l_fields VARCHAR2(10000);
10525: l_no_of_masters NUMBER := 0;
10526: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;
10527: l_last_dedupe_by ams_list_headers_all.last_deduped_by_user_id%TYPE;
10528: l_dedupe_key ams_list_entries.dedupe_key%TYPE;
10529: l_dedupe_key_count NUMBER;
10530: l_rank_count NUMBER;