DBA Data[Home] [Help]

APPS.JA_CN_CFSSE_CALCULATE_PKG dependencies on GL_LEDGERS

Line 57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb

53: ,p_period_name IN VARCHAR2
54: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL) IS
55:
56: l_procedure_name VARCHAR2(30) := 'Populate_LastYear_Period_Names';
57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb
58: l_period_set_name gl_periods.period_set_name%TYPE;
59: l_period_type gl_periods.period_type%TYPE;
60: l_period_name gl_periods.period_name%TYPE := p_period_name;
61: l_cur_period_year gl_periods.period_year%TYPE;

Line 75: gl_ledgers

71: SELECT
72: period_set_name
73: ,accounted_period_type
74: FROM
75: gl_ledgers
76: WHERE ledger_id=l_ledger_id;
77:
78: -- this cursor is
79: CURSOR c_cur_period_year IS

Line 198: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;

194: l_format_mask VARCHAR2(100);
195: l_final_display_format VARCHAR2(30);
196: l_legal_entity_id NUMBER := p_legal_entity_id;
197: -- l_set_of_bks_id gl_sets_of_books.set_of_books_id%TYPE := p_set_of_bks_id;
198: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
199: l_func_currency_code fnd_currencies.currency_code%TYPE;
200: l_period_name gl_periods.period_name%TYPE := p_period_name;
201: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE := p_axis_set_id;
202: l_rounding_option VARCHAR2(50) := p_rounding_option;

Line 331: gl_ledgers

327: currency_code
328: INTO
329: l_func_currency_code
330: FROM
331: gl_ledgers
332: WHERE
333: ledger_id=l_ledger_id ;
334:
335: l_format_mask := FND_CURRENCY.Get_Format_Mask(currency_code => l_func_currency_code,