APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_RULE_USAGES

Line 6823: FROM ams_list_rule_usages

6819: --Bug 5235979. Bmuthukr
6820:
6821: /* cursor c1 is
6822: SELECT list_rule_id
6823: FROM ams_list_rule_usages
6824: WHERE list_header_id = g_list_header_id;*/
6825:
6826: CURSOR C1 IS
6827: SELECT us.list_rule_id

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

9454: --Bug 5235979. Bmuthukr
9455:
9456: /* cursor c1 is
9457: SELECT list_rule_id
9458: FROM ams_list_rule_usages
9459: WHERE list_header_id = g_list_header_id;*/
9460:
9461: CURSOR C1 IS
9462: SELECT us.list_rule_id

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

10374: IS
10375: -- the set of rules associated with a list.
10376: CURSOR c_list_rules (my_list_header_id IN NUMBER)
10377: IS SELECT list_rule_id
10378: FROM ams_list_rule_usages
10379: WHERE list_header_id = my_list_header_id
10380: ORDER BY priority;
10381:
10382: -- the list of fields for the list rule which are used to generate the key.