APPS.CS_SRCONTACT_PKG dependencies on HZ_RELATIONSHIPS

Line 1405: from HZ_PARTIES p, HZ_RELATIONSHIPS r

1401: from HZ_PARTIES where party_id = l_primary_contact_id;
1402: ELSIF l_primary_contact_type = 'PARTY_RELATIONSHIP'
1403: THEN
1404: select PERSON_LAST_NAME,PERSON_FIRST_NAME into l_last_name,l_first_name
1405: from HZ_PARTIES p, HZ_RELATIONSHIPS r
1406: where r.party_id = l_primary_contact_id
1407: and r.subject_id = p.party_id
1408: and r.subject_type = 'PERSON'
1409: and r.subject_table_name = 'HZ_PARTIES'