APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_OBJECT_ASSOCIATIONS

Line 168: FROM ams_object_associations

164: SELECT object_association_id,
165: object_version_number,
166: using_object_id,
167: using_object_type
168: FROM ams_object_associations
169: WHERE master_object_type = 'CAMP'
170: AND master_object_id = p_campaign_id
171: AND using_object_type in ('EVEH', 'EVEO');
172:

Line 178: -- FROM ams_object_associations

174: -- SELECT 1
175: -- FROM DUAL
176: -- WHERE EXISTS(
177: -- SELECT 1
178: -- FROM ams_object_associations
179: -- WHERE master_object_type = 'CAMP'
180: -- AND using_object_type = p_event_type
181: -- AND using_object_id = p_event_id);
182:

Line 190: FROM ams_object_associations

186: -- Check that the event is not associated to any other campaign
187: --
188: CURSOR c_event_used IS
189: SELECT master_object_id
190: FROM ams_object_associations
191: WHERE master_object_type = 'CAMP'
192: AND using_object_type = p_event_type
193: AND using_object_id = p_event_id;
194: l_master_id NUMBER ;

Line 2174: FROM ams_object_associations

2170: l_dummy NUMBER;
2171:
2172: CURSOR c_camp_deliv IS
2173: SELECT 1
2174: FROM ams_object_associations
2175: WHERE master_object_type = 'CAMP'
2176: AND master_object_id = p_camp_id
2177: AND using_object_type = 'DELV'
2178: AND using_object_id = p_deliv_id;