APPS.GL_PERIODS_PKG dependencies on GL_LEDGERS

Line 382: gl_ledgers led

378: DECLARE
379: CURSOR chk_actual IS
380: SELECT 'Opened'
381: FROM gl_period_statuses ps,
382: gl_ledgers led
383: WHERE ps.application_id IN (101, 275, 283)
384: AND ps.period_name = check_period_used.period_name
385: AND ps.closing_status <> 'N'
386: AND ps.ledger_id = led.ledger_id+0

Line 418: gl_ledgers led

414: SELECT 'Used for budgets'
415: FROM gl_budgets b,
416: gl_budget_versions bv,
417: gl_budget_period_ranges bpr,
418: gl_ledgers led
419: WHERE bv.budget_name = b.budget_name
420: AND bv.budget_type = b.budget_type
421: AND bpr.budget_version_id = bv.budget_version_id
422: AND bpr.period_year =

Line 453: FROM gl_ledgers led

449: -- Check for use with encumbrances
450: DECLARE
451: CURSOR chk_encumbrance IS
452: SELECT 'Used for encumbrances'
453: FROM gl_ledgers led
454: WHERE led.period_set_name =
455: check_period_used.calendar_name
456: AND led.accounted_period_type = check_period_used.period_type
457: AND led.latest_encumbrance_year >=

Line 1324: FROM gl_ledgers

1320: AND period_type = x_period_type
1321: AND period_year = x_period_year
1322: AND ledger_id IN
1323: (SELECT ledger_id
1324: FROM gl_ledgers
1325: WHERE period_set_name = x_period_set_name);
1326:
1327: END maintain_quarter_start_date;
1328:

Line 1380: FROM gl_ledgers

1376: period_type = x_period_type
1377: AND period_year = x_period_year
1378: AND ledger_id IN
1379: (SELECT ledger_id
1380: FROM gl_ledgers
1381: WHERE period_set_name = x_period_set_name);
1382:
1383: END maintain_year_start_date;
1384:

Line 1394: FROM gl_ledgers

1390: CURSOR check_LED IS
1391: SELECT '1' FROM sys.dual
1392: WHERE EXISTS
1393: (SELECT 'Calendar used in LED with Average Balancing enabled'
1394: FROM gl_ledgers
1395: WHERE
1396: period_set_name = x_period_set_name
1397: AND enable_average_balances_flag= 'Y'
1398: );