APPS.OPI_DBI_COGS_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

1457: -- same as the primary, don't call the API but rather use an update
1458: -- statement followed by the insert.
1459:
1460: -- By selecting distinct org and currency code from the gl_set_of_books
1461: -- and hr_organization_information, take care of duplicate codes.
1462:
1463: INSERT /*+ append parallel(rates) */
1464: INTO opi_dbi_cogsf_conv_rates rates (
1465: organization_id,

Line 1494: FROM hr_organization_information hoi,

1490: FROM opi_dbi_cogs_fstg) to_conv,
1491: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
1492: parallel (hoi) parallel (gsob)*/
1493: DISTINCT hoi.organization_id, gsob.currency_code
1494: FROM hr_organization_information hoi,
1495: gl_sets_of_books gsob
1496: WHERE hoi.org_information_context = 'Accounting Information'
1497: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1498: curr_codes

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

1713: -- same as the primary, don't call the API but rather use an update
1714: -- statement followed by the insert.
1715:
1716: -- By selecting distinct org and currency code from the gl_set_of_books
1717: -- and hr_organization_information, take care of duplicate codes.
1718:
1719: INSERT /*+ append */
1720: INTO opi_dbi_cogsf_conv_rates rates (
1721: organization_id,

Line 1749: FROM hr_organization_information hoi,

1745: DISTINCT organization_id, trunc (cogs_date) cogs_date
1746: FROM opi_dbi_cogs_fstg) to_conv,
1747: (SELECT
1748: DISTINCT hoi.organization_id, gsob.currency_code
1749: FROM hr_organization_information hoi,
1750: gl_sets_of_books gsob
1751: WHERE hoi.org_information_context = 'Accounting Information'
1752: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1753: curr_codes