APPS.XLA_UPG_VERIFICATION_PUB dependencies on GL_LEDGERS

Line 822: ,gl_ledgers gll

818: ELSE 'N' END header_error4-- Balance type code invalid
819: ,CASE when xe.event_id IS NULL THEN 'Y'
820: ELSE 'N' END header_error5-- Header without valid event
821: from xla_ae_headers xah
822: ,gl_ledgers gll
823: ,xla_events xe
824: where gll.ledger_id (+) = xah.ledger_id
825: and xe.event_id (+) = xah.event_id
826: and (gll.ledger_id IS NULL OR

Line 872: from gl_ledgers gll

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
873: where gll.suspense_allowed_flag = 'N')
874: group by xal.ae_header_id
875: having nvl(sum(accounted_dr), 0)
876: <> nvl(sum(accounted_cr), 0)

Line 1109: , gl_ledgers gll

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
1112: WHERE glcc.code_combination_id(+) = xal.code_combination_id
1113: AND xah.ae_header_id(+) = xal.ae_header_id

Line 1411: gl_ledgers gll,

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
1414: and xah.application_id = p_application_id
1415: and xah.ae_header_id = xal.ae_header_id

Line 1486: gl_ledgers gll,

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
1489: and xah.application_id = p_application_id
1490: and xah.ae_header_id = xal.ae_header_id