APPS.INV_ORGHIERARCHY_PVT dependencies on GL_SETS_OF_BOOKS

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:

Line 1541: --FROM GL_SETS_OF_BOOKS

1537: AND set_of_books_id = to_number(org_information1);
1538:
1539: -- rschaub: too expensive
1540: --SELECT period_set_name
1541: --FROM GL_SETS_OF_BOOKS
1542: --WHERE SET_OF_BOOKS_ID IN (SELECT set_of_books_id
1543: -- FROM ORG_ORGANIZATION_DEFINITIONS
1544: -- WHERE ORGANIZATION_ID = c_organization_id);
1545: