APPS.INV_RCV_COMMON_APIS dependencies on GL_SETS_OF_BOOKS

Line 1584: FROM org_organization_definitions ood, gl_sets_of_books sob

1580: SELECT ood.set_of_books_id
1581: , sob.currency_code
1582: INTO x_sob_id
1583: , x_currency_code
1584: FROM org_organization_definitions ood, gl_sets_of_books sob
1585: WHERE organization_id = p_org_id
1586: AND sob.set_of_books_id = ood.set_of_books_id;
1587: */
1588: x_inv_org_id := p_org_id; --bug 5195963

Line 1594: FROM hr_organization_information hoi, gl_sets_of_books sob

1590: SELECT TO_NUMBER(hoi.org_information1)
1591: , sob.currency_code
1592: INTO x_sob_id
1593: , x_currency_code
1594: FROM hr_organization_information hoi, gl_sets_of_books sob
1595: WHERE hoi.organization_id = p_org_id
1596: AND (hoi.org_information_context || '') = 'Accounting Information'
1597: AND sob.set_of_books_id = to_number(hoi.org_information1);
1598:

Line 1816: FROM org_organization_definitions ood, gl_sets_of_books sob

1812: SELECT ood.set_of_books_id
1813: , sob.currency_code
1814: INTO g_po_startup_value.sob_id
1815: , g_po_startup_value.currency_code
1816: FROM org_organization_definitions ood, gl_sets_of_books sob
1817: WHERE organization_id = p_organization_id
1818: AND sob.set_of_books_id = ood.set_of_books_id;
1819: */
1820:

Line 1825: FROM hr_organization_information hoi, gl_sets_of_books sob

1821: SELECT TO_NUMBER(hoi.org_information1)
1822: , sob.currency_code
1823: INTO g_po_startup_value.sob_id
1824: , g_po_startup_value.currency_code
1825: FROM hr_organization_information hoi, gl_sets_of_books sob
1826: WHERE hoi.organization_id = p_organization_id
1827: AND (hoi.org_information_context || '') = 'Accounting Information'
1828: AND sob.set_of_books_id = to_number(hoi.org_information1);
1829: