APPS.FV_1219_TRANSACTIONS dependencies on GL_LEDGERS_PUBLIC_V

Line 39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;

35: l_batch_id FV_SF1219_TEMP.batch_id%TYPE;
36:
37: l_je_header_id gl_je_headers.je_header_id%TYPE;
38: l_je_line_num gl_je_lines.je_line_num%TYPE;
39: l_currency_code gl_ledgers_public_v.currency_code%TYPE;
40:
41: l_reference_1 FV_SF1219_TEMP.reference_1%TYPE;
42: l_reference_2 FV_SF1219_TEMP.reference_2%TYPE;
43: l_reference_3 FV_SF1219_TEMP.reference_3%TYPE;

Line 232: FROM gl_ledgers_public_v

228: END IF;
229:
230: SELECT currency_code
231: INTO l_currency_code
232: FROM gl_ledgers_public_v
233: WHERE ledger_id = p_set_bks_id;
234:
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 379: FROM gl_ledgers_public_v

375: l_error_code BOOLEAN;
376: BEGIN
377: SELECT chart_of_accounts_id
378: INTO flex_num
379: FROM gl_ledgers_public_v
380: WHERE ledger_id = p_set_bks_id ;
381:
382: fv_utility.get_segment_col_names(flex_num,
383: gl_seg_name ,

Line 428: gl_ledgers_public_v gsob

424:
425: SELECT distinct year_start_date
426: INTO l_yr_start_date
427: FROM gl_periods glp,
428: gl_ledgers_public_v gsob
429: WHERE gsob.ledger_id = p_set_bks_id
430: AND gsob.period_set_name = glp.period_set_name
431: AND gsob.chart_of_accounts_id = flex_num
432: AND period_name = p_gl_period;

Line 447: gl_ledgers_public_v gsob

443:
444: SELECT start_date, end_date, period_year
445: INTO l_start_date1, l_end_date1, l_period_year
446: FROM gl_periods glp,
447: gl_ledgers_public_v gsob
448: WHERE glp.period_name = p_gl_period
449: AND glp.period_type = period_type
450: AND gsob.ledger_id = p_set_bks_id
451: AND gsob.chart_of_accounts_id = flex_num

Line 459: FROM gl_periods glp, gl_ledgers_public_v gsob

455:
456: -- Determine the last date of the period year
457: SELECT MAX(glp.end_date)
458: INTO l_yr_end_date
459: FROM gl_periods glp, gl_ledgers_public_v gsob
460: WHERE glp.period_year = l_period_year
461: AND gsob.ledger_id = p_set_bks_id
462: AND glp.period_set_name = gsob.period_set_name;
463: