APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_RULES_ALL

Line 6828: FROM ams_list_rule_usages us, ams_list_rules_all rules

6824: WHERE list_header_id = g_list_header_id;*/
6825:
6826: CURSOR C1 IS
6827: SELECT us.list_rule_id
6828: FROM ams_list_rule_usages us, ams_list_rules_all rules
6829: WHERE us.list_header_id = g_list_header_id
6830: AND us.list_rule_id = rules.list_rule_id
6831: AND rules.list_source_type = l_listheader_rec.list_source_type
6832: AND rules.list_rule_type = 'TARGET';

Line 9463: FROM ams_list_rule_usages us, ams_list_rules_all rules

9459: WHERE list_header_id = g_list_header_id;*/
9460:
9461: CURSOR C1 IS
9462: SELECT us.list_rule_id
9463: FROM ams_list_rule_usages us, ams_list_rules_all rules
9464: WHERE us.list_header_id = g_list_header_id
9465: AND us.list_rule_id = rules.list_rule_id
9466: AND rules.list_source_type = l_listheader_rec.list_source_type
9467: AND rules.list_rule_type = 'TARGET';

Line 10385: ams_list_rules_all.list_rule_id%TYPE)

10381:
10382: -- the list of fields for the list rule which are used to generate the key.
10383: CURSOR c_rule_fields
10384: (my_list_rule_id IN
10385: ams_list_rules_all.list_rule_id%TYPE)
10386: IS
10387: SELECT field_table_name,
10388: field_column_name,
10389: substring_length,

Line 10425: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;

10421: l_sql_stmt2 VARCHAR2(10000);
10422:
10423: l_fields VARCHAR2(10000);
10424: l_no_of_masters NUMBER := 0;
10425: l_list_rule_id ams_list_rules_all.list_rule_id%TYPE;
10426: l_last_dedupe_by ams_list_headers_all.last_deduped_by_user_id%TYPE;
10427: l_dedupe_key ams_list_entries.dedupe_key%TYPE;
10428: l_dedupe_key_count NUMBER;
10429: l_rank_count NUMBER;