APPS.OPI_DBI_INV_CCA_PKG dependencies on GL_SETS_OF_BOOKS

Line 1924: gl_sets_of_books gsob

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
1928: WHERE curr_codes.organization_id = to_conv.organization_id;

Line 3673: gl_sets_of_books gsob

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
3677: WHERE curr_codes.organization_id = to_conv.organization_id;