APPS.XLA_UPGRADE_PUB dependencies on XLA_AE_LINES

Line 81: xla_ae_lines.ae_line_num%type

77: TYPE t_header_id IS TABLE OF
78: xla_ae_headers.ae_header_id%type
79: INDEX BY BINARY_INTEGER;
80: TYPE t_line_num IS TABLE OF
81: xla_ae_lines.ae_line_num%type
82: INDEX BY BINARY_INTEGER;
83: TYPE t_seg_value IS TABLE OF
84: xla_ae_segment_values.segment_value%type
85: INDEX BY BINARY_INTEGER;

Line 2543: from xla_ae_lines xal

2539: case when nvl(sum(accounted_dr), 0) <> nvl(sum(accounted_cr), 0)
2540: then 'Y' else 'N' end header_error1, -- amts not balanced,
2541: case when nvl(sum(entered_dr), 0) <> nvl(sum(entered_cr), 0)
2542: then 'Y' else 'N' end header_error2 -- entered amts not balanced
2543: from xla_ae_lines xal
2544: where xal.application_id = p_application_id
2545: and xal.ae_header_id = p_header_id
2546: and xal.currency_code <> 'STAT'
2547: and xal.ledger_id in (select gll.ledger_id

Line 2587: from xla_ae_lines xal

2583: ,'XLA_UPG_HDR_WO_LINES'
2584: from (select xah.ae_header_id
2585: from xla_ae_headers xah
2586: where NOT EXISTS (SELECT xal.ae_header_id
2587: from xla_ae_lines xal
2588: where xah.ae_header_id = xal.ae_header_id
2589: and xah.application_id = xal.application_id
2590: and xal.application_id = p_application_id
2591: and xal.ae_header_id = p_header_id)

Line 2700: , xla_ae_lines xal

2696: , CASE when xal.party_site_id IS NULL
2697: and xal.party_id IS NULL then 'Y'
2698: ELSE 'N' END line_error10
2699: FROM xla_ae_headers xah
2700: , xla_ae_lines xal
2701: , gl_code_combinations glcc
2702: , gl_ledgers gll
2703: , hz_parties hz
2704: , hz_party_sites hps