DBA Data[Home] [Help]

APPS.GL_RX_TRIAL_BALANCE_PKG dependencies on GL_LEDGERS

Line 19: l_ledger_id GL_LEDGERS.ledger_id%type;

15: p_summary_digits in number default 1,
16: p_statutory_rfj_flag in varchar2 default 'N') IS
17:
18: l_request_id FND_CONCURRENT_REQUESTS.request_id%type;
19: l_ledger_id GL_LEDGERS.ledger_id%type;
20: l_functional_currency GL_LEDGERS.currency_code%type;
21: l_currency_code GL_LEDGERS.currency_code%type;
22: l_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%type;
23: l_fiscal_year GL_PERIOD_STATUSES.period_year%type;

Line 20: l_functional_currency GL_LEDGERS.currency_code%type;

16: p_statutory_rfj_flag in varchar2 default 'N') IS
17:
18: l_request_id FND_CONCURRENT_REQUESTS.request_id%type;
19: l_ledger_id GL_LEDGERS.ledger_id%type;
20: l_functional_currency GL_LEDGERS.currency_code%type;
21: l_currency_code GL_LEDGERS.currency_code%type;
22: l_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%type;
23: l_fiscal_year GL_PERIOD_STATUSES.period_year%type;
24: l_first_period_name GL_PERIOD_STATUSES.period_name%type;

Line 21: l_currency_code GL_LEDGERS.currency_code%type;

17:
18: l_request_id FND_CONCURRENT_REQUESTS.request_id%type;
19: l_ledger_id GL_LEDGERS.ledger_id%type;
20: l_functional_currency GL_LEDGERS.currency_code%type;
21: l_currency_code GL_LEDGERS.currency_code%type;
22: l_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%type;
23: l_fiscal_year GL_PERIOD_STATUSES.period_year%type;
24: l_first_period_name GL_PERIOD_STATUSES.period_name%type;
25: l_adjustment_flag GL_PERIOD_STATUSES.adjustment_period_flag%type;

Line 22: l_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%type;

18: l_request_id FND_CONCURRENT_REQUESTS.request_id%type;
19: l_ledger_id GL_LEDGERS.ledger_id%type;
20: l_functional_currency GL_LEDGERS.currency_code%type;
21: l_currency_code GL_LEDGERS.currency_code%type;
22: l_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%type;
23: l_fiscal_year GL_PERIOD_STATUSES.period_year%type;
24: l_first_period_name GL_PERIOD_STATUSES.period_name%type;
25: l_adjustment_flag GL_PERIOD_STATUSES.adjustment_period_flag%type;
26: l_balancing_where varchar2(240);

Line 84: FROM gl_ledgers led,

80: INTO l_ledger_id,
81: l_functional_currency,
82: l_chart_of_accounts_id,
83: l_fiscal_year
84: FROM gl_ledgers led,
85: gl_period_statuses ps
86: WHERE led.name = p_ledger_name
87: AND led.ledger_id = ps.ledger_id
88: AND ps.application_id = l_application_id