APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_RULE_USAGES

Line 6880: FROM ams_list_rule_usages

6876: --Bug 5235979. Bmuthukr
6877:
6878: /* cursor c1 is
6879: SELECT list_rule_id
6880: FROM ams_list_rule_usages
6881: WHERE list_header_id = g_list_header_id;*/
6882:
6883: CURSOR C1 IS
6884: SELECT us.list_rule_id

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 9559: FROM ams_list_rule_usages

9555: --Bug 5235979. Bmuthukr
9556:
9557: /* cursor c1 is
9558: SELECT list_rule_id
9559: FROM ams_list_rule_usages
9560: WHERE list_header_id = g_list_header_id;*/
9561:
9562: CURSOR C1 IS
9563: SELECT us.list_rule_id

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 10479: FROM ams_list_rule_usages

10475: IS
10476: -- the set of rules associated with a list.
10477: CURSOR c_list_rules (my_list_header_id IN NUMBER)
10478: IS SELECT list_rule_id
10479: FROM ams_list_rule_usages
10480: WHERE list_header_id = my_list_header_id
10481: ORDER BY priority;
10482:
10483: -- the list of fields for the list rule which are used to generate the key.