APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on GL_LEDGERS

Line 230: FROM gl_ledgers

226: SELECT end_date --- removed start_date
227: INTO l_sec_alc_end_date
228: FROM gl_period_statuses
229: WHERE period_name = (SELECT latest_opened_period_name -- removed first_ledger_period_name
230: FROM gl_ledgers
231: WHERE ledger_id = l_primary_ledger_id) -- removed l_secondary_alc_ledger_id
232: AND ledger_id = l_primary_ledger_id
233: AND application_id = 101;
234:

Line 275: FROM gl_ledgers

271:
272:
273: SELECT currency_code
274: INTO l_primary_currency_code
275: FROM gl_ledgers
276: WHERE ledger_id = l_primary_ledger_id;
277:
278:
279: SELECT ledger_category_code, currency_code

Line 281: FROM gl_ledgers

277:
278:
279: SELECT ledger_category_code, currency_code
280: INTO l_ledger_category_code, l_sec_alc_currency_code
281: FROM gl_ledgers
282: WHERE ledger_id = l_secondary_alc_ledger_id;
283:
284: SELECT minimum_accountable_unit, precision
285: INTO l_sec_alc_mau, l_sec_alc_precision

Line 3076: FROM gl_ledgers

3072:
3073:
3074: SELECT period_set_name, accounted_period_type
3075: INTO l_primary_cal_set_name, l_primary_cal_per_type
3076: FROM gl_ledgers
3077: WHERE ledger_id = l_primary_ledger_id;
3078:
3079:
3080: SELECT period_set_name, accounted_period_type

Line 3082: FROM gl_ledgers

3078:
3079:
3080: SELECT period_set_name, accounted_period_type
3081: INTO l_primary_sec_alc_set_name, l_primary_sec_alc_per_type
3082: FROM gl_ledgers
3083: WHERE ledger_id = l_secondary_alc_ledger_id;
3084:
3085:
3086: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN