DBA Data[Home] [Help]

APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_RELATIONSHIPS

Line 985: hz_relationships hzr,

981: select hcpp.contact_point_id contact_point_id,
982: hcpp.owner_table_id contact_point_owner_id,
983: hcpp.owner_table_name contact_point_owner_name
984: from hz_parties hp,
985: hz_relationships hzr,
986: hz_party_usg_assignments hpua,
987: HZ_CONTACT_POINTS hcpp
988: where hp.party_id = hzr.subject_id
989: and hzr.subject_id = l_per_party_id /* bug 9604355 */

Line 1060: FROM hz_relationships

1056: BEGIN
1057: SELECT relationship_id,
1058: party_id
1059: INTO l_relationship_id,l_party_id
1060: FROM hz_relationships
1061: WHERE subject_id = l_relationship_rec.subject_id
1062: AND subject_type = 'PERSON'
1063: AND object_id = l_relationship_rec.object_id
1064: AND object_type = 'ORGANIZATION'