APPS.OPI_DBI_INV_CCA_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

1886: -- same as the primary, don't call the API but rather use an update
1887: -- statement followed by the insert.
1888:
1889: -- By selecting distinct org and currency code from the gl_set_of_books
1890: -- and hr_organization_information, take care of duplicate codes.
1891:
1892: INSERT /*+ append parallel (opi_dbi_inv_cca_conv) */
1893: INTO opi_dbi_inv_cca_conv (
1894: organization_id,

Line 1923: FROM hr_organization_information hoi,

1919: FROM opi_dbi_inv_cca_stg) to_conv,
1920: (SELECT /*+ leading (hoi) full (hoi) use_hash (gsob)
1921: parallel (hoi) parallel (gsob)*/
1922: DISTINCT hoi.organization_id, gsob.currency_code
1923: FROM hr_organization_information hoi,
1924: gl_sets_of_books gsob
1925: WHERE hoi.org_information_context = 'Accounting Information'
1926: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1927: curr_codes

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

3636: -- same as the primary, don't call the API but rather use an update
3637: -- statement followed by the insert.
3638:
3639: -- By selecting distinct org and currency code from the gl_set_of_books
3640: -- and hr_organization_information, take care of duplicate codes.
3641:
3642: INSERT /*+ append */
3643: INTO opi_dbi_inv_cca_conv (
3644: organization_id,

Line 3672: FROM hr_organization_information hoi,

3668: DISTINCT organization_id, approval_date
3669: FROM opi_dbi_inv_cca_stg) to_conv,
3670: (SELECT
3671: DISTINCT hoi.organization_id, gsob.currency_code
3672: FROM hr_organization_information hoi,
3673: gl_sets_of_books gsob
3674: WHERE hoi.org_information_context = 'Accounting Information'
3675: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
3676: curr_codes