DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_CST_ETL_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 243: -- and hr_organization_information, take care of duplicate codes.

239: -- -1 for dates for which there is no currency conversion rate
240: -- -2 for unrecognized currency conversion rates
241:
242: -- By selecting distinct org and currency code from the gl_set_of_books
243: -- and hr_organization_information, take care of duplicate codes.
244:
245: l_stmt_id := 60;
246: insert /*+ append */
247: into isc_maint_wo_cst_conv_rates

Line 304: hr_organization_information hoi

300: , ( select distinct
301: hoi.organization_id
302: , gsob.currency_code
303: from
304: hr_organization_information hoi
305: , gl_sets_of_books gsob
306: where hoi.org_information_context = 'Accounting Information'
307: and hoi.org_information1 = to_char(gsob.set_of_books_id)
308: ) c