eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_TP_BALANCE_RPT_PKG dependencies on GL_LEDGERS

Line 430: CURSOR c_alc_ledger_check(l_ledger_id gl_ledgers.ledger_id%TYPE) IS

426: l_temp number;
427:
428:
429: --bug#7828983
430: CURSOR c_alc_ledger_check(l_ledger_id gl_ledgers.ledger_id%TYPE) IS
431: SELECT primary_ledger_id
432: FROM gl_ledger_relationships
433: WHERE target_ledger_id = l_ledger_id
434: AND relationship_type_code = 'SUBLEDGER'

Line 438: l_primary_ledger_id gl_ledgers.ledger_id%TYPE;

434: AND relationship_type_code = 'SUBLEDGER'
435: AND target_ledger_category_code = 'ALC'
436: AND application_id =101;
437:
438: l_primary_ledger_id gl_ledgers.ledger_id%TYPE;
439: --end bug#7828983
440:
441: BEGIN
442:

Line 525: FROM gl_ledgers

521: -- Identifying ledger as Ledger or Ledger Set and get value for language
522: --
523: SELECT object_type_code, USERENV('LANG')
524: INTO l_object_type, l_lang
525: FROM gl_ledgers
526: WHERE ledger_id = p_ledger_id;
527:
528: IF(P_JE_SOURCE='ALL') THEN
529: select application_id

Line 631: FROM gl_ledgers

627: --
628:
629: SELECT chart_of_accounts_id
630: INTO l_coa_id
631: FROM gl_ledgers
632: WHERE ledger_id = p_ledger_id;
633:
634: ----------------------------------------------------------------------------
635: -- get qualifier segments for the COA

Line 1365: FROM gl_ledgers gll

1361: ,gcck.segment27 SEGMENT27
1362: ,gcck.segment28 SEGMENT28
1363: ,gcck.segment29 SEGMENT29
1364: ,gcck.segment30 SEGMENT30
1365: FROM gl_ledgers gll
1366: ,xla_control_balances xcb
1367: ,gl_period_statuses gls
1368: ,gl_code_combinations_kfv gcck
1369: ,hz_parties hzp