DBA Data[Home] [Help]

APPS.ISC_MAINT_CURRENCY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 22: hr_organization_information hoi

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)

Line 36: hr_organization_information hoi

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)