APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on GL_SETS_OF_BOOKS

Line 263: FROM gl_sets_of_books sob,

259: WHERE attribute_value = 'Y'
260: AND segment_attribute_type = 'GL_ACCOUNT'
261: AND id_flex_num in
262: (SELECT chart_of_accounts_id
263: FROM gl_sets_of_books sob,
264: ar_system_parameters sys
265: WHERE sob.set_of_books_id = sys.set_of_books_id);
266:
267: BEGIN

Line 432: FROM gl_sets_of_books sob,

428: l_precision fnd_currencies.precision%TYPE;
429:
430: CURSOR precision IS
431: SELECT cur.precision
432: FROM gl_sets_of_books sob,
433: fnd_currencies cur
434: WHERE sob.currency_code = cur.currency_code
435: AND sob.set_of_books_id = arp_standard.sysparm.set_of_books_id;
436:

Line 1490: FROM gl_sets_of_books

1486: l_mrc_sob_type_code VARCHAR2(1);
1487:
1488: CURSOR sob_type IS
1489: SELECT mrc_sob_type_code
1490: FROM gl_sets_of_books
1491: WHERE set_of_books_id = p_set_of_books_id;
1492:
1493: CURSOR system_options IS
1494: select set_of_books_id

Line 1689: FROM gl_sets_of_books sob

1685: INTO l_sob_name,
1686: l_sob_id,
1687: l_functional_currency,
1688: l_chart_of_accounts_id
1689: FROM gl_sets_of_books sob
1690: WHERE sob.set_of_books_id = p_reporting_entity_id;
1691:
1692: ELSIF p_reporting_level = 3000 THEN
1693: SELECT sob.name sob_name,

Line 1703: FROM gl_sets_of_books sob,

1699: l_sob_id,
1700: l_functional_currency,
1701: l_chart_of_accounts_id,
1702: l_organization
1703: FROM gl_sets_of_books sob,
1704: ar_system_parameters_all sysparam,
1705: hr_organization_units hou
1706: WHERE sob.set_of_books_id = sysparam.set_of_books_id
1707: AND hou.organization_id = sysparam.org_id