APPS.HZ_MERGE_PARTIES_PUB dependencies on HZ_RELATIONSHIPS

Line 256: FROM HZ_RELATIONSHIPS --4500011

252: AND batch_id = cp_batch_id;
253:
254: CURSOR c_check_hq_branch( cp_from_party_id IN NUMBER, cp_to_party_id IN NUMBER ) IS
255: SELECT 1
256: FROM HZ_RELATIONSHIPS --4500011
257: WHERE content_source_type = 'DNB'
258: AND subject_id = cp_from_party_id
259: AND object_id = cp_to_party_id
260: AND RELATIONSHIP_CODE = 'HEADQUARTERS_OF'