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 1340: gl_sets_of_books, hr_organization_information

1336: period_set_name
1337: INTO
1338: l_calendar_name
1339: FROM
1340: gl_sets_of_books, hr_organization_information
1341: WHERE UPPER( org_information_context ) = UPPER( 'Accounting Information' )
1342: AND organization_id = l_org_id
1343: AND set_of_books_id = TO_NUMBER(org_information1);
1344:

Line 1404: gl_sets_of_books, hr_organization_information

1400: chart_of_accounts_id
1401: INTO
1402: l_chart_of_accounts_id
1403: FROM
1404: gl_sets_of_books, hr_organization_information
1405: WHERE UPPER( org_information_context ) = UPPER( 'Accounting Information' )
1406: AND organization_id = l_org_id
1407: AND set_of_books_id = TO_NUMBER(org_information1);
1408:

Line 1518: gl_sets_of_books, hr_organization_information

1514: CURSOR c_chart_of_accounts(c_organization_id NUMBER) IS
1515: SELECT
1516: chart_of_accounts_id
1517: FROM
1518: gl_sets_of_books, hr_organization_information
1519: WHERE upper( org_information_context ) = upper( 'Accounting Information' )
1520: AND organization_id = c_organization_id
1521: AND set_of_books_id = to_number(org_information1);
1522:

Line 1534: gl_sets_of_books, hr_organization_information

1530:
1531: SELECT
1532: period_set_name
1533: FROM
1534: gl_sets_of_books, hr_organization_information
1535: WHERE upper( org_information_context ) = upper( 'Accounting Information' )
1536: AND organization_id = c_organization_id
1537: AND set_of_books_id = to_number(org_information1);
1538: