APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

256: -- same as the primary, don't call the API but rather use an update
257: -- statement followed by the insert.
258:
259: -- By selecting distinct org and currency code from the gl_set_of_books
260: -- and hr_organization_information, take care of duplicate codes.
261: --
262: -- Since OPM uses it's own currency conversion rate logic,
263: -- just filter out rows with source = 2.
264: INSERT /*+ append parallel (opi_dbi_conversion_rates) */

Line 329: FROM hr_organization_information hoi,

325: ) to_conv,
326: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
327: parallel (hoi) parallel (gsob)*/
328: DISTINCT hoi.organization_id, gsob.currency_code
329: FROM hr_organization_information hoi,
330: gl_sets_of_books gsob
331: WHERE hoi.org_information_context = 'Accounting Information'
332: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
333: curr_codes