APPS.WSH_ROUTING_RESPONSE_PKG dependencies on HZ_RELATIONSHIPS

Line 1019: hz_relationships hrel

1015: hz_parties contact_person,
1016: hz_org_contacts supplier_contact,
1017: hz_contact_points phone_record,
1018: hz_contact_points email_record,
1019: hz_relationships hrel
1020: WHERE hps.party_site_id = hpsu.party_site_id
1021: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
1022: AND hrel.subject_id = contact_person.party_id
1023: AND hrel.subject_table_name = 'HZ_PARTIES'

Line 1048: FROM fnd_user fu, hz_relationships hz

1044: WHERE name = 'HZ_PARTY:' || p_relId;
1045: --
1046: CURSOR c_GetPOUser(p_vendorID NUMBER) IS
1047: SELECT fu.user_name, fu.email_address
1048: FROM fnd_user fu, hz_relationships hz
1049: WHERE hz.subject_id = p_vendorId
1050: AND hz.object_id = fu.person_party_id --IB-phase-2 Vendor Merge
1051: AND hz.subject_type = 'ORGANIZATION'
1052: AND hz.object_type = 'PERSON'

Line 1613: FROM hz_relationships rel,

1609:
1610: --Cursor to find,if carrier is auto load tender enable.
1611: CURSOR validate_auto_tender_csr(p_carrier_id NUMBER,p_organization_id NUMBER) IS
1612: SELECT 1
1613: FROM hz_relationships rel,
1614: wsh_carrier_sites wcs,
1615: hz_party_sites hps,
1616: hz_org_contacts hoc,
1617: hz_contact_points hcp,