APPS.XLA_UPGRADE_PUB dependencies on GL_LEDGERS

Line 1060: FROM gl_ledgers l

1056: FROM gl_period_statuses gps
1057: WHERE gps.migration_status_code = 'U'
1058: AND gps.application_id IN (275,8721)
1059: AND gps.ledger_id IN (SELECT l.ledger_id
1060: FROM gl_ledgers l
1061: WHERE l.ledger_id IN (SELECT DISTINCT target_ledger_id
1062: FROM gl_ledger_relationships glr
1063: WHERE glr.primary_ledger_id = i_ledger_id
1064: AND glr.application_id = 101

Line 1082: FROM gl_ledgers l

1078: FROM gl_period_statuses gps
1079: WHERE gps.migration_status_code = 'U'
1080: AND gps.application_id = i_application_id
1081: AND gps.ledger_id IN (SELECT l.ledger_id
1082: FROM gl_ledgers l
1083: WHERE l.ledger_id IN (SELECT DISTINCT target_ledger_id
1084: FROM gl_ledger_relationships glr
1085: WHERE glr.primary_ledger_id = i_ledger_id
1086: AND glr.application_id = 101

Line 1284: FROM gl_ledgers l

1280: FROM gl_period_statuses gps
1281: WHERE gps.migration_status_code = 'P'
1282: AND gps.application_id IN (275, 8721)
1283: AND gps.ledger_id IN ( SELECT l.ledger_id
1284: FROM gl_ledgers l
1285: WHERE l.ledger_id IN (SELECT DISTINCT glr.target_ledger_id
1286: FROM gl_ledger_relationships glr
1287: WHERE glr.primary_ledger_id = p_ledger_id
1288: AND glr.application_id = 101

Line 1345: FROM gl_ledgers l

1341: FROM gl_period_statuses gps
1342: WHERE gps.migration_status_code = 'P'
1343: AND gps.application_id = l_application_id
1344: AND gps.ledger_id IN (SELECT l.ledger_id
1345: FROM gl_ledgers l
1346: WHERE l.ledger_id IN (SELECT DISTINCT glr.target_ledger_id
1347: FROM gl_ledger_relationships glr
1348: WHERE glr.primary_ledger_id = p_ledger_id
1349: AND glr.application_id = 101

Line 1405: FROM gl_ledgers l

1401: END IF;
1402:
1403: SELECT l.name
1404: INTO l_upg_ledger_name
1405: FROM gl_ledgers l
1406: WHERE l.ledger_id = l_upg_ledger_id ;
1407:
1408:
1409:

Line 2496: ,gl_ledgers gll

2492: ELSE 'N' END header_error4-- Balance type code invalid
2493: ,CASE when xe.event_id IS NULL THEN 'Y'
2494: ELSE 'N' END header_error5-- Header without valid event
2495: from xla_ae_headers xah
2496: ,gl_ledgers gll
2497: ,xla_events xe
2498: where gll.ledger_id (+) = xah.ledger_id
2499: and xe.event_id (+) = xah.event_id
2500: and (gll.ledger_id IS NULL OR

Line 2548: from gl_ledgers gll

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
2548: from gl_ledgers gll
2549: where gll.suspense_allowed_flag = 'N')
2550: group by xal.ae_header_id
2551: having nvl(sum(accounted_dr), 0)
2552: <> nvl(sum(accounted_cr), 0)

Line 2702: , gl_ledgers gll

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