164: -- same as the primary, don't call the API but rather use an update
165: -- statement followed by the insert.
166:
167: -- By selecting distinct org and currency code from the gl_set_of_books
168: -- and hr_organization_information, take care of duplicate codes.
169: INSERT /*+ append parallel(rates) */
170: INTO opi_dbi_muv_conv_rates rates (
171: organization_id,
172: f_currency_code,
216: ) to_conv,
217: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
218: parallel (hoi) parallel (gsob)*/
219: DISTINCT hoi.organization_id, gsob.currency_code
220: FROM hr_organization_information hoi,
221: gl_sets_of_books gsob
222: WHERE hoi.org_information_context = 'Accounting Information'
223: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
224: curr_codes