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_BALANCES_CALC_PKG dependencies on XLA_AE_HEADERS

Line 227: FROM xla_ae_headers xah

223: BULK COLLECT INTO
224: g_ledger_array
225: , g_application_array
226: , g_accounting_batch_array
227: FROM xla_ae_headers xah
228: , xla_ae_lines xal
229: , gl_period_statuses gps
230: , xla_ledger_relationships_v xlr
231: WHERE xah.application_id = p_application_id

Line 280: from xla_ae_headers

276: BULK COLLECT INTO
277: g_ledger_array
278: , g_application_array
279: , g_accounting_batch_array
280: from xla_ae_headers
281: where application_id = p_application_id
282: and entity_id = p_entity_id;
283:
284:

Line 310: from xla_ae_headers

306: BULK COLLECT INTO
307: g_ledger_array
308: , g_application_array
309: , g_accounting_batch_array
310: from xla_ae_headers
311: where application_id = p_application_id
312: and ae_header_id = p_ae_header_id;
313:
314: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST

Line 340: from xla_ae_headers

336: BULK COLLECT INTO
337: g_ledger_array
338: , g_application_array
339: , g_accounting_batch_array
340: from xla_ae_headers
341: where accounting_batch_id = p_accounting_batch_id
342: and application_id = p_application_id;
343:
344: FORALL i in g_ledger_array.FIRST..g_ledger_array.LAST

Line 530: FROM xla_ae_headers aeh

526: , gps.effective_period_num
527: , $period_balance_dr$
528: , $period_balance_cr$
529: , SUBSTR (gps.effective_period_num, 1, 4) period_year
530: FROM xla_ae_headers aeh
531: , xla_ae_lines ael
532: , xla_ae_line_acs acs
533: , xla_analytical_hdrs_b xbh
534: , gl_period_statuses gps

Line 1370: FROM xla_ae_headers aeh

1366: AND (ae_header_id,ae_line_num) IN
1367: ( SELECT /*+ $parallel$ leading(aeh) */
1368: ael.ae_header_id
1369: ,ael.ae_line_num
1370: FROM xla_ae_headers aeh
1371: , xla_ae_lines ael
1372: , gl_period_statuses gps
1373: , xla_ledger_options xlo
1374: , xla_ledger_relationships_v xlr

Line 1632: FROM xla_ae_headers aeh

1628: , gps.effective_period_num
1629: , $period_balance_dr$
1630: , $period_balance_cr$
1631: , SUBSTR (gps.effective_period_num, 1, 4) period_year
1632: FROM xla_ae_headers aeh
1633: , xla_ae_lines ael
1634: , gl_period_statuses gps
1635: , xla_ledger_options xlo
1636: , xla_ledger_relationships_v xlr

Line 2341: FROM xla_ae_headers aeh

2337: AND control_balance_flag = '''||g_preupdate_flag||'''
2338: AND (ae_header_id,ae_line_num) IN ( SELECT /*+ $parallel$ leading(aeh) */
2339: ael.ae_header_id
2340: ,ael.ae_line_num
2341: FROM xla_ae_headers aeh
2342: , xla_ae_lines ael
2343: , gl_period_statuses gps
2344: , xla_ledger_options xlo
2345: , xla_ledger_relationships_v xlr

Line 2678: ,xla_ae_headers xah

2674: )gps_effective_period_num
2675: , xlo.ledger_id
2676: FROM xla_ledger_options xlo
2677: ,xla_ledger_relationships_v xlr
2678: ,xla_ae_headers xah
2679: WHERE xlo.ledger_id = DECODE(xlr.ledger_category_code , ''ALC''
2680: ,xlr.primary_ledger_id, xlr.ledger_id)
2681: AND xlo.application_id = '||p_application_id||'
2682: AND xah.application_id = ' ||p_application_id ||'

Line 4915: ,xla_ae_headers xah

4911: from xla_ae_lines xal
4912: ,xla_ae_line_acs xac
4913: ,gl_period_statuses gps1
4914: ,gl_period_statuses gps2
4915: ,xla_ae_headers xah
4916: where xah.application_id = :'||to_number(l_bind_count)||'
4917: and xah.ledger_id = :'||to_number(l_bind_count+1)||'
4918: and xah.accounting_date between gps1.start_date and gps2.end_date
4919: and xal.application_id = xah.application_id