APPS.AR_BPA_UTILS_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 515: FROM hz_cust_account_roles acct_role,

511: /* Return contact name */
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'

Line 546: hz_cust_account_roles acct_role

542: CURSOR c_cont_phone( id in number ) IS
543: select min(decode(cont_point.contact_point_type,'TLX',
544: cont_point.telex_number, cont_point.phone_number)) contact_phone
545: from hz_contact_points cont_point,
546: hz_cust_account_roles acct_role
547: where acct_role.cust_account_role_id = id
548: and acct_role.party_id = cont_point.owner_table_id
549: and cont_point.owner_table_name = 'HZ_PARTIES'
550: and nvl(cont_point.phone_line_type, cont_point.contact_point_type) = 'GEN';

Line 572: hz_cust_account_roles acct_role

568: CURSOR c_cont_fax( id in number ) IS
569: select min(decode(cont_point.contact_point_type,'TLX',
570: cont_point.telex_number, cont_point.phone_number)) contact_fax
571: from hz_contact_points cont_point,
572: hz_cust_account_roles acct_role
573: where acct_role.cust_account_role_id = id
574: and acct_role.party_id = cont_point.owner_table_id
575: and cont_point.owner_table_name = 'HZ_PARTIES'
576: and nvl(cont_point.phone_line_type, cont_point.contact_point_type) = 'FAX';