APPS.INV_ORGHIERARCHY_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 188: hr_organization_information hoi,

184: ( SELECT l_sec_origin_org_id FROM DUAL WHERE l_include_origin_flag = 'Y')
185: )
186: ),
187: hr_all_organization_units org,
188: hr_organization_information hoi,
189: mtl_parameters mp
190: WHERE
191: org.organization_id = hoi.organization_id
192: AND org.organization_id = mp.organization_id

Line 230: , hr_organization_information hoi

226: AND arc.org_structure_version_id = l_hierarchy_version_id
227: )
228:
229: , hr_all_organization_units org
230: , hr_organization_information hoi
231: , mtl_parameters mp
232:
233:
234: WHERE

Line 305: , hr_organization_information hoi

301: )
302:
303:
304: , hr_all_organization_units org
305: , hr_organization_information hoi
306: , mtl_parameters mp
307:
308:
309: WHERE

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: