APPS.ASO_PARTY_INT dependencies on HZ_ORG_CONTACTS

Line 1423: hz_org_contacts org

1419:
1420: CURSOR C_party(l_org_contact_id NUMBER) IS
1421: SELECT par.party_id
1422: FROM hz_relationships par,
1423: hz_org_contacts org
1424: WHERE org.party_relationship_id = par.relationship_id
1425: AND org.org_contact_id = l_org_contact_id
1426: and par.subject_type = 'PERSON'
1427: and par.subject_table_name ='HZ_PARTIES';

Line 1627: FROM hz_org_contacts oc, hz_parties p, hz_relationships pr

1623: l_api_name CONSTANT VARCHAR2(45) := 'Create_ORG_CONTACT_ORD';
1624:
1625: Cursor C_org_contact (l_party_id NUMBER, l_header_party_id NUMBER) IS
1626: SELECT OC.org_contact_id
1627: FROM hz_org_contacts oc, hz_parties p, hz_relationships pr
1628: WHERE p.party_id = l_party_id
1629: AND p.party_id = pr.subject_id
1630: AND pr.object_id = l_header_party_id
1631: AND (pr.relationship_type = 'CONTACT'