DBA Data[Home] [Help]

APPS.AR_BPA_UTILS_PKG dependencies on HZ_RELATIONSHIPS

Line 516: hz_relationships rel,

512: FUNCTION fn_get_contact_name (p_contact_id IN NUMBER) return varchar2 IS
513: CURSOR c_cont_name( id in number ) IS
514: SELECT party.person_first_name ||' '|| party.person_last_name attn
515: FROM hz_cust_account_roles acct_role,
516: hz_relationships rel,
517: hz_parties party
518: WHERE acct_role.cust_account_role_id = id
519: AND acct_role.ROLE_TYPE = 'CONTACT'
520: AND acct_role.party_id = rel.party_id