APPS.OPI_DBI_RES_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

424: -- same as the primary, don't call the API but rather use an update
425: -- statement followed by the insert.
426:
427: -- By selecting distinct org and currency code from the gl_set_of_books
428: -- and hr_organization_information, take care of duplicate codes.
429: INSERT /*+ append parallel(rates) */
430: INTO opi_dbi_res_conv_rates rates (
431: organization_id,
432: f_currency_code,

Line 470: FROM hr_organization_information hoi,

466: parallel (hoi) parallel (gsob)*/
467: DISTINCT
468: hoi.organization_id,
469: gsob.currency_code
470: FROM hr_organization_information hoi,
471: gl_sets_of_books gsob
472: WHERE hoi.org_information_context = 'Accounting Information'
473: AND hoi.org_information1 = to_char(gsob.set_of_books_id)) curr_codes
474: WHERE curr_codes.organization_id = to_conv.organization_id;