APPS.WSH_LOCATIONS_PKG dependencies on HZ_PARTY_USG_ASSIGNMENTS
Line 1983: hz_party_usg_assignments hzusg
1979: UNION ALL
1980: SELECT 4
1981: FROM hz_parties hz,
1982: ap_suppliers su, 1983: hz_party_usg_assignments hzusg 1984: WHERE hz.party_id = su.party_id
1985: AND hz.party_id = hzusg.party_id
1986: AND hzusg.PARTY_USAGE_CODE = 'SUPPLIER'
1987: AND su.party_id = l_party_id;