APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTIES

Line 782: hz_parties hp, fnd_user fu , hz_relationships hzr,

778: hcpp.contact_point_id contact_point_id,
779: hcpp.owner_table_id contact_point_owner_id,
780: hcpp.owner_table_name contact_point_owner_name
781: from
782: hz_parties hp, fnd_user fu , hz_relationships hzr,
783: hz_party_usg_assignments hpua , HZ_CONTACT_POINTS hcpp
784: where hp.party_id = hzr.subject_id
785: and hzr.object_id = l_from_party_id ---:1 -- party of supplier
786: and hzr.relationship_type = 'CONTACT'

Line 804: And hcpp.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

800: )
801: and hpua.party_id = hp.party_id
802: and hpua.status_flag = 'A'
803: and hpua.party_usage_code = 'SUPPLIER_CONTACT'
804: And hcpp.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
805: And hcpp.OWNER_TABLE_ID(+) = hzr.PARTY_ID
806: And hcpp.status (+)='A'
807: ;
808:

Line 825: l_relationship_rec.subject_table_name := 'HZ_PARTIES';

821:
822: --Initialization of new relationship rec - relationship between 'To Party' and 'Contact'
823: l_relationship_rec.subject_id := contact_loop_c.per_party_id;
824: l_relationship_rec.subject_type := 'PERSON';
825: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
826: l_relationship_rec.object_id := p_to_org_party_id;
827: l_relationship_rec.object_type := 'ORGANIZATION';
828: l_relationship_rec.object_table_name := 'HZ_PARTIES';
829: l_relationship_rec.relationship_code := 'CONTACT_OF';

Line 828: l_relationship_rec.object_table_name := 'HZ_PARTIES';

824: l_relationship_rec.subject_type := 'PERSON';
825: l_relationship_rec.subject_table_name := 'HZ_PARTIES';
826: l_relationship_rec.object_id := p_to_org_party_id;
827: l_relationship_rec.object_type := 'ORGANIZATION';
828: l_relationship_rec.object_table_name := 'HZ_PARTIES';
829: l_relationship_rec.relationship_code := 'CONTACT_OF';
830: l_relationship_rec.relationship_type := 'CONTACT';
831: l_relationship_rec.status := 'A';
832: l_relationship_rec.created_by_module:='AP_SUPPLIERS_API';