1035: FROM opi_dbi_wip_comp_stg) to_conv,
1036: (SELECT
1037: DISTINCT hoi.organization_id, gsob.currency_code
1038: FROM hr_organization_information hoi,
1039: gl_sets_of_books gsob
1040: WHERE hoi.org_information_context = 'Accounting Information'
1041: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1042: curr_codes
1043: WHERE curr_codes.organization_id = to_conv.organization_id;