APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on GL_SETS_OF_BOOKS

Line 237: FROM gl_sets_of_books sob,

233: WHERE attribute_value = 'Y'
234: AND segment_attribute_type = 'GL_ACCOUNT'
235: AND id_flex_num in
236: (SELECT chart_of_accounts_id
237: FROM gl_sets_of_books sob,
238: ar_system_parameters sys
239: WHERE sob.set_of_books_id = sys.set_of_books_id);
240:
241: BEGIN

Line 406: FROM gl_sets_of_books sob,

402: l_precision fnd_currencies.precision%TYPE;
403:
404: CURSOR precision IS
405: SELECT cur.precision
406: FROM gl_sets_of_books sob,
407: fnd_currencies cur
408: WHERE sob.currency_code = cur.currency_code
409: AND sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
410:

Line 1461: FROM gl_sets_of_books

1457: l_mrc_sob_type_code VARCHAR2(1);
1458:
1459: CURSOR sob_type IS
1460: SELECT mrc_sob_type_code
1461: FROM gl_sets_of_books
1462: WHERE set_of_books_id = p_set_of_books_id;
1463:
1464: CURSOR system_options IS
1465: select set_of_books_id

Line 1660: FROM gl_sets_of_books sob

1656: INTO l_sob_name,
1657: l_sob_id,
1658: l_functional_currency,
1659: l_chart_of_accounts_id
1660: FROM gl_sets_of_books sob
1661: WHERE sob.set_of_books_id = p_reporting_entity_id;
1662:
1663: ELSIF p_reporting_level = 3000 THEN
1664: SELECT sob.name sob_name,

Line 1674: FROM gl_sets_of_books sob,

1670: l_sob_id,
1671: l_functional_currency,
1672: l_chart_of_accounts_id,
1673: l_organization
1674: FROM gl_sets_of_books sob,
1675: ar_system_parameters_all sysparam,
1676: hr_organization_units hou
1677: WHERE sob.set_of_books_id = sysparam.set_of_books_id
1678: AND hou.organization_id = sysparam.org_id