APPS.FUN_TRX_PVT dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 324: FROM hz_party_usg_assignments hua

320: SELECT le.le_effective_from, le.le_effective_to
321: FROM xle_firstparty_information_v le, hz_parties parties
322: WHERE parties.party_id = p_party_id
323: AND EXISTS (SELECT 1
324: FROM hz_party_usg_assignments hua
325: WHERE hua.party_id = parties.party_id
326: AND hua.party_usage_code = 'INTERCOMPANY_ORG')
327: AND fun_tca_pkg.get_le_id(p_party_id) = le.party_id
328: AND p_le_id = le.legal_entity_id;