18: cursor c_one_org_currency(b_org_id number) is
19: select distinct
20: gsob.currency_code
21: from
22: hr_organization_information hoi
23: , gl_sets_of_books gsob
24: , mtl_parameters mp
25: where hoi.org_information_context = 'Accounting Information'
26: and hoi.org_information1 = to_char(gsob.set_of_books_id)
32: select distinct
33: gsob.currency_code
34: , count(distinct gsob.currency_code) over() currency_count
35: from
36: hr_organization_information hoi
37: , gl_sets_of_books gsob
38: , mtl_parameters mp
39: where hoi.org_information_context = 'Accounting Information'
40: and hoi.org_information1 = to_char(gsob.set_of_books_id)