APPS.AS_TAP_MERGE_PKG dependencies on AS_TERRITORY_ACCESSES

Line 135: DELETE FROM as_territory_accesses

131: IF p_parent_entity_name = 'HZ_PARTIES' THEN
132: FOR I in c_get_pm_access_id (p_from_fk_id, p_to_fk_id) LOOP
133: FND_FILE.PUT_LINE(FND_FILE.LOG,
134: 'Deleting PARTY access_id: '||I.access_id);
135: DELETE FROM as_territory_accesses
136: WHERE access_id = I.access_id;
137:
138: DELETE FROM as_accesses_all
139: WHERE access_id = I.access_id;

Line 203: DELETE FROM as_territory_accesses

199: -- delete duplicate records (which will violate unique constraint)
200: FOR I in c_get_psm_access_id (p_from_fk_id, p_to_fk_id) LOOP
201: FND_FILE.PUT_LINE(FND_FILE.LOG,
202: 'Deleting PARTY SITE access_id: '||I.access_id);
203: DELETE FROM as_territory_accesses
204: WHERE access_id = I.access_id;
205:
206: DELETE FROM as_accesses_all
207: WHERE access_id = I.access_id;