DBA Data[Home] [Help]

APPS.FUN_SECURITY dependencies on HZ_ORG_CONTACTS

Line 262: FROM hz_relationships hzr, hz_org_contacts hc, hz_org_contact_roles hcr

258: END IF;
259:
260: SELECT hcr.org_contact_role_id, hcr.org_contact_id, hcr.primary_flag, hcr.status
261: INTO l_org_contact_role_id, l_org_contact_id, l_primary_flag, l_status
262: FROM hz_relationships hzr, hz_org_contacts hc, hz_org_contact_roles hcr
263: WHERE hzr.subject_id=p_person_id
264: AND hzr.object_id=v_org_record.partyid
265: AND hzr.relationship_code='CONTACT_OF'
266: AND hzr.relationship_type='CONTACT'