APPS.INV_ORGHIERARCHY_PVT dependencies on GL_SETS_OF_BOOKS

Line 1717: gl_sets_of_books, hr_organization_information

1713: period_set_name
1714: INTO
1715: l_calendar_name
1716: FROM
1717: gl_sets_of_books, hr_organization_information
1718: WHERE UPPER( org_information_context ) = UPPER( 'Accounting Information' )
1719: AND organization_id = l_org_id
1720: AND set_of_books_id = TO_NUMBER(org_information1);
1721:

Line 1781: gl_sets_of_books, hr_organization_information

1777: chart_of_accounts_id
1778: INTO
1779: l_chart_of_accounts_id
1780: FROM
1781: gl_sets_of_books, hr_organization_information
1782: WHERE UPPER( org_information_context ) = UPPER( 'Accounting Information' )
1783: AND organization_id = l_org_id
1784: AND set_of_books_id = TO_NUMBER(org_information1);
1785:

Line 1895: gl_sets_of_books, hr_organization_information

1891: CURSOR c_chart_of_accounts(c_organization_id NUMBER) IS
1892: SELECT
1893: chart_of_accounts_id
1894: FROM
1895: gl_sets_of_books, hr_organization_information
1896: WHERE upper( org_information_context ) = upper( 'Accounting Information' )
1897: AND organization_id = c_organization_id
1898: AND set_of_books_id = to_number(org_information1);
1899:

Line 1911: gl_sets_of_books, hr_organization_information

1907:
1908: SELECT
1909: period_set_name
1910: FROM
1911: gl_sets_of_books, hr_organization_information
1912: WHERE upper( org_information_context ) = upper( 'Accounting Information' )
1913: AND organization_id = c_organization_id
1914: AND set_of_books_id = to_number(org_information1);
1915:

Line 1918: --FROM GL_SETS_OF_BOOKS

1914: AND set_of_books_id = to_number(org_information1);
1915:
1916: -- rschaub: too expensive
1917: --SELECT period_set_name
1918: --FROM GL_SETS_OF_BOOKS
1919: --WHERE SET_OF_BOOKS_ID IN (SELECT set_of_books_id
1920: -- FROM ORG_ORGANIZATION_DEFINITIONS
1921: -- WHERE ORGANIZATION_ID = c_organization_id);
1922: