DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_LEDGERS

Line 383: FROM gl_ledgers

379: BEGIN -- Deriving the period_set_name,currency code
380:
381: SELECT period_set_name,currency_code,accounted_period_type
382: INTO g_period_set_name,g_currency_code,g_accounted_period_type
383: FROM gl_ledgers
384: WHERE ledger_id = g_ledger_id;
385:
386: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): Period Set Name: '||g_period_set_name||', Currency Code:'||g_currency_code||', Accounted Period Type :'||g_accounted_period_type);
387:

Line 7364: gl_ledgers gl

7360:
7361: SELECT COUNT(*)
7362: INTO l_cnt
7363: FROM gl_periods gp,
7364: gl_ledgers gl
7365: WHERE gp.period_set_name = gl.period_set_name
7366: AND gl.ledger_id = g_ledger_id
7367: AND g_start_date >= gp.start_date
7368: AND g_end_date <= gp.end_date ;