DBA Data[Home] [Help]

APPS.ISC_FS_INV_USG_ETL_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

233: -- -1 for dates for which there is no currency conversion rate
234: -- -2 for unrecognized currency conversion rates
235:
236: -- By selecting distinct org and currency code from the gl_set_of_books
237: -- and hr_organization_information, take care of duplicate codes.
238:
239: l_stmt_num := 60;
240: INSERT /*+ append */
241: INTO ISC_FS_INV_USG_CONV_RATES

Line 291: hr_organization_information hoi

287: , ( SELECT DISTINCT
288: hoi.organization_id
289: , gsob.currency_code
290: FROM
291: hr_organization_information hoi
292: , gl_sets_of_books gsob
293: WHERE hoi.org_information_context = 'Accounting Information'
294: AND hoi.org_information1 = to_char(gsob.set_of_books_id)
295: ) c