APPS.HR_PERSON dependencies on PER_ADDRESSES

Line 2194: from per_addresses pa

2190: select 'Error : Primary address exists'
2191: into v_dummy
2192: from sys.dual
2193: where exists (select 'address exists'
2194: from per_addresses pa
2195: where pa.person_id = p_person_id
2196: and pa.business_group_id +0 = p_business_group_id
2197: and (pa.address_id <> p_address_id
2198: or p_address_id is null)