APPS.AR_BPA_UTILS_PKG dependencies on HZ_PARTIES

Line 525: hz_parties party

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'
528: AND acct_role.party_id = rel.party_id
529: AND rel.subject_id = party.party_id

Line 530: AND rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

526: WHERE acct_role.cust_account_role_id = id
527: AND acct_role.ROLE_TYPE = 'CONTACT'
528: AND acct_role.party_id = rel.party_id
529: AND rel.subject_id = party.party_id
530: AND rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
531: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
532: AND rel.DIRECTIONAL_FLAG = 'F';
533:
534: l_contact_name varchar2(240) := null;

Line 531: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

527: AND acct_role.ROLE_TYPE = 'CONTACT'
528: AND acct_role.party_id = rel.party_id
529: AND rel.subject_id = party.party_id
530: AND rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
531: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
532: AND rel.DIRECTIONAL_FLAG = 'F';
533:
534: l_contact_name varchar2(240) := null;
535: BEGIN

Line 562: and cont_point.owner_table_name = 'HZ_PARTIES'

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';
564: l_phone varchar2(240) := null;
565: BEGIN
566: FOR crec IN c_cont_phone(p_contact_id)

Line 588: and cont_point.owner_table_name = 'HZ_PARTIES'

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';
590: l_fax varchar2(240) := null;
591: BEGIN
592: FOR crec IN c_cont_fax(p_contact_id)