DBA Data[Home] [Help]

APPS.ISC_MAINT_CURRENCY_PKG dependencies on GL_SETS_OF_BOOKS

Line 23: , gl_sets_of_books gsob

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)
27: and hoi.organization_id = mp.organization_id

Line 37: , gl_sets_of_books gsob

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)
41: and hoi.organization_id = mp.organization_id