DBA Data[Home] [Help]

APPS.HZ_COMMON_PUB dependencies on HZ_RELATIONSHIPS

Line 449: hz_relationships c

445: cursor c is
446: select b.person_first_name||' '||b.person_last_name
447: from hz_cust_account_roles a,
448: hz_parties b,
449: hz_relationships c
450: where a.cust_account_role_id = v_contact_id
451: and c.party_id =a.party_id
452: and c.subject_id = b.party_id
453: and c.subject_table_name = 'HZ_PARTIES'