APPS.XLA_UPGRADE_PUB dependencies on XLA_AE_LINES

Line 73: xla_ae_lines.ae_line_num%type

69: TYPE t_header_id IS TABLE OF
70: xla_ae_headers.ae_header_id%type
71: INDEX BY BINARY_INTEGER;
72: TYPE t_line_num IS TABLE OF
73: xla_ae_lines.ae_line_num%type
74: INDEX BY BINARY_INTEGER;
75: TYPE t_seg_value IS TABLE OF
76: xla_ae_segment_values.segment_value%type
77: INDEX BY BINARY_INTEGER;

Line 1484: from xla_ae_lines xal

1480: case when nvl(sum(accounted_dr), 0) <> nvl(sum(accounted_cr), 0)
1481: then 'Y' else 'N' end header_error1, -- amts not balanced,
1482: case when nvl(sum(entered_dr), 0) <> nvl(sum(entered_cr), 0)
1483: then 'Y' else 'N' end header_error2 -- entered amts not balanced
1484: from xla_ae_lines xal
1485: where xal.application_id = p_application_id
1486: and xal.ae_header_id = p_header_id
1487: and xal.currency_code <> 'STAT'
1488: and xal.ledger_id in (select gll.ledger_id

Line 1528: from xla_ae_lines xal

1524: ,'XLA_UPG_HDR_WO_LINES'
1525: from (select xah.ae_header_id
1526: from xla_ae_headers xah
1527: where NOT EXISTS (SELECT xal.ae_header_id
1528: from xla_ae_lines xal
1529: where xah.ae_header_id = xal.ae_header_id
1530: and xah.application_id = xal.application_id
1531: and xal.application_id = p_application_id
1532: and xal.ae_header_id = p_header_id)

Line 1641: , xla_ae_lines xal

1637: , CASE when xal.party_site_id IS NULL
1638: and xal.party_id IS NULL then 'Y'
1639: ELSE 'N' END line_error10
1640: FROM xla_ae_headers xah
1641: , xla_ae_lines xal
1642: , gl_code_combinations glcc
1643: , gl_ledgers gll
1644: , hz_parties hz
1645: , hz_party_sites hps