273: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
274: parallel (hoi) parallel (gsob)*/
275: DISTINCT hoi.organization_id, gsob.currency_code
276: FROM hr_organization_information hoi,
277: gl_sets_of_books gsob
278: WHERE hoi.org_information_context = 'Accounting Information'
279: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
280: curr_codes
281: WHERE curr_codes.organization_id = to_conv.organization_id;