APPS.AR_BPA_UTILS_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 523: FROM hz_cust_account_roles acct_role,

519: FUNCTION fn_get_contact_name (p_contact_id IN NUMBER) return varchar2 IS
520: CURSOR c_cont_name( id in number ) IS
521: SELECT party.person_first_name fname
522: ,party.person_last_name lname
523: FROM hz_cust_account_roles acct_role,
524: hz_relationships rel,
525: hz_parties party
526: WHERE acct_role.cust_account_role_id = id
527: AND acct_role.ROLE_TYPE = 'CONTACT'

Line 559: hz_cust_account_roles acct_role

555: CURSOR c_cont_phone( id in number ) IS
556: select min(decode(cont_point.contact_point_type,'TLX',
557: cont_point.telex_number, cont_point.phone_number)) contact_phone
558: from hz_contact_points cont_point,
559: hz_cust_account_roles acct_role
560: where acct_role.cust_account_role_id = id
561: and acct_role.party_id = cont_point.owner_table_id
562: and cont_point.owner_table_name = 'HZ_PARTIES'
563: and nvl(cont_point.phone_line_type, cont_point.contact_point_type) = 'GEN';

Line 585: hz_cust_account_roles acct_role

581: CURSOR c_cont_fax( id in number ) IS
582: select min(decode(cont_point.contact_point_type,'TLX',
583: cont_point.telex_number, cont_point.phone_number)) contact_fax
584: from hz_contact_points cont_point,
585: hz_cust_account_roles acct_role
586: where acct_role.cust_account_role_id = id
587: and acct_role.party_id = cont_point.owner_table_id
588: and cont_point.owner_table_name = 'HZ_PARTIES'
589: and nvl(cont_point.phone_line_type, cont_point.contact_point_type) = 'FAX';