APPS.FUN_TRX_PVT dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 277: FROM hz_party_usg_assignments hua

273: SELECT le.le_effective_from, le.le_effective_to
274: FROM xle_firstparty_information_v le, hz_parties parties
275: WHERE parties.party_id = p_party_id
276: AND EXISTS (SELECT 1
277: FROM hz_party_usg_assignments hua
278: WHERE hua.party_id = parties.party_id
279: AND hua.party_usage_code = 'INTERCOMPANY_ORG')
280: AND fun_tca_pkg.get_le_id(p_party_id) = le.party_id
281: AND p_le_id = le.legal_entity_id;