APPS.AS_TAP_MERGE_PKG dependencies on AS_TERRITORY_ACCESSES

Line 133: DELETE FROM as_territory_accesses

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

Line 186: DELETE FROM as_territory_accesses

182: -- delete duplicate records (which will violate unique constraint)
183: FOR I in c_get_psm_access_id (p_from_fk_id, p_to_fk_id) LOOP
184: FND_FILE.PUT_LINE(FND_FILE.LOG,
185: 'Deleting PARTY SITE access_id: '||I.access_id);
186: DELETE FROM as_territory_accesses
187: WHERE access_id = I.access_id;
188:
189: DELETE FROM as_accesses_all
190: WHERE access_id = I.access_id;