APPS.XLA_UPG_VERIFICATION_PUB dependencies on XLA_AE_LINES

Line 52: xla_ae_lines.ae_line_num%type

48: TYPE t_header_id IS TABLE OF
49: xla_ae_headers.ae_header_id%type
50: INDEX BY BINARY_INTEGER;
51: TYPE t_line_num IS TABLE OF
52: xla_ae_lines.ae_line_num%type
53: INDEX BY BINARY_INTEGER;
54: TYPE t_seg_value IS TABLE OF
55: xla_ae_segment_values.segment_value%type
56: INDEX BY BINARY_INTEGER;

Line 868: from xla_ae_lines xal

864: case when nvl(sum(accounted_dr), 0) <> nvl(sum(accounted_cr), 0)
865: then 'Y' else 'N' end header_error1, -- amts not balanced,
866: case when nvl(sum(entered_dr), 0) <> nvl(sum(entered_cr), 0)
867: then 'Y' else 'N' end header_error2 -- entered amts not balanced
868: from xla_ae_lines xal
869: where xal.application_id = p_application_id
870: and xal.currency_code <> 'STAT'
871: and xal.ledger_id in (select gll.ledger_id
872: from gl_ledgers gll

Line 908: from xla_ae_lines xal

904: ,'XLA_UPG_HDR_WO_LINES'
905: from (select xah.ae_header_id
906: from xla_ae_headers xah
907: where NOT EXISTS (SELECT xal.ae_header_id
908: from xla_ae_lines xal
909: where xah.ae_header_id = xal.ae_header_id
910: and xah.application_id = xal.application_id
911: and xal.application_id = p_application_id)
912: and application_id = p_application_id

Line 1107: , xla_ae_lines xal

1103: , CASE when xal.party_site_id IS NULL
1104: and xal.party_id IS NULL then 'Y'
1105: ELSE 'N' END line_error10
1106: FROM xla_ae_headers xah
1107: , xla_ae_lines xal
1108: , gl_code_combinations glcc
1109: , gl_ledgers gll
1110: , hz_parties hz
1111: , hz_party_sites hps

Line 1285: from xla_ae_lines xal

1281: ,'XLA_UPG_LINK_NO_LINE'
1282: from (select xdl.ae_header_id, xdl.ae_line_num,xdl.temp_line_num
1283: from xla_distribution_links xdl
1284: where not exists (SELECT xal.ae_header_id, xal.ae_line_num
1285: from xla_ae_lines xal
1286: where xal.ae_header_id = xdl.ae_header_id
1287: and xal.ae_line_num = xdl.ae_line_num
1288: and xal.application_id = p_application_id)
1289: and xdl.application_id = p_application_id));

Line 1409: from xla_ae_lines xal,

1405: 'SEGMENT28', ccid.segment28,
1406: 'SEGMENT29', ccid.segment29,
1407: 'SEGMENT30', ccid.segment30,
1408: NULL), count(*)
1409: from xla_ae_lines xal,
1410: xla_ae_headers xah,
1411: gl_ledgers gll,
1412: gl_code_combinations ccid
1413: where gll.ledger_id = xah.ledger_id

Line 1484: from xla_ae_lines xal,

1480: 'SEGMENT28', ccid.segment28,
1481: 'SEGMENT29', ccid.segment29,
1482: 'SEGMENT30', ccid.segment30,
1483: NULL), count(*)
1484: from xla_ae_lines xal,
1485: xla_ae_headers xah,
1486: gl_ledgers gll,
1487: gl_code_combinations ccid
1488: where gll.ledger_id = xah.ledger_id