APPS.GL_RX_TRIAL_BALANCE_PKG dependencies on GL_PERIOD_STATUSES

Line 23: l_fiscal_year GL_PERIOD_STATUSES.period_year%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);
27: l_account_from_where varchar2(240);

Line 24: l_first_period_name GL_PERIOD_STATUSES.period_name%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);
27: l_account_from_where varchar2(240);
28: l_account_to_where varchar2(240);

Line 25: l_adjustment_flag GL_PERIOD_STATUSES.adjustment_period_flag%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);
27: l_account_from_where varchar2(240);
28: l_account_to_where varchar2(240);
29: l_translate_where varchar2(240);

Line 85: gl_period_statuses ps

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
89: AND ps.period_name = p_period_name;

Line 103: FROM gl_period_statuses

99: SELECT period_name,
100: adjustment_period_flag
101: INTO l_first_period_name,
102: l_adjustment_flag
103: FROM gl_period_statuses
104: WHERE application_id = l_application_id
105: AND ledger_id = l_ledger_id
106: AND period_year = l_fiscal_year
107: AND period_num = ( SELECT MIN(period_num)

Line 108: FROM gl_period_statuses

104: WHERE application_id = l_application_id
105: AND ledger_id = l_ledger_id
106: AND period_year = l_fiscal_year
107: AND period_num = ( SELECT MIN(period_num)
108: FROM gl_period_statuses
109: WHERE application_id = l_application_id
110: AND ledger_id = l_ledger_id
111: AND period_year = l_fiscal_year);
112: --