APPS.AMS_ACT_LIST_PVT dependencies on AMS_LIST_RULE_USAGES

Line 2273: ams_list_rule_usages am,

2269: SELECT am.list_rule_id,
2270: ac.campaign_id,
2271: ac.activity_id
2272: FROM ams_campaign_schedules_b ac,
2273: ams_list_rule_usages am,
2274: ams_list_headers_all al
2275: WHERE al.list_used_by_id = ac.schedule_id
2276: AND am.list_header_id(+) = al.list_header_id
2277: AND ac.schedule_id = p_list_used_by_id

Line 3964: select list_rule_id from ams_list_rule_usages

3960:
3961: -- ckapoor R12 dedupe rule copy
3962:
3963: CURSOR c_dedupe_rule(p_list_header_id IN NUMBER) is
3964: select list_rule_id from ams_list_rule_usages
3965: where list_header_id = p_list_header_id;
3966: -- ckapoor end R12 dedupe rule copy
3967:
3968: l_excluded_list_size NUMBER;

Line 4171: -- insert a new row in ams_list_rule_usages

4167: OPEN c_dedupe_rule(l_old_list_header_id);
4168: FETCH c_dedupe_rule INTO l_list_rule_id;
4169: CLOSE c_dedupe_rule;
4170:
4171: -- insert a new row in ams_list_rule_usages
4172:
4173: if (l_list_rule_id is not null) then
4174:
4175: insert into ams_list_rule_usages

Line 4175: insert into ams_list_rule_usages

4171: -- insert a new row in ams_list_rule_usages
4172:
4173: if (l_list_rule_id is not null) then
4174:
4175: insert into ams_list_rule_usages
4176: (LIST_RULE_USAGE_ID, LIST_HEADER_ID, LIST_RULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4177: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, ACTIVE_FROM_DATE,
4178: ACTIVE_TO_DATE, PRIORITY, SECURITY_GROUP_ID)
4179: values (

Line 4180: ams_list_rule_usages_s.nextval,

4176: (LIST_RULE_USAGE_ID, LIST_HEADER_ID, LIST_RULE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4177: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, ACTIVE_FROM_DATE,
4178: ACTIVE_TO_DATE, PRIORITY, SECURITY_GROUP_ID)
4179: values (
4180: ams_list_rule_usages_s.nextval,
4181: l_list_header_id,
4182: l_list_rule_id,
4183: sysdate,
4184: FND_GLOBAL.User_Id,