[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bv.budget_version_id, b.budget_name,
b.require_budget_journals_flag
FROM gl_budgets b, gl_budget_versions bv
WHERE b.ledger_id = x_ledger_id
AND b.status = 'C'
AND bv.budget_name = b.budget_name
AND bv.budget_type = b.budget_type;
SELECT 'Funding budget'
FROM gl_budget_assignment_ranges rng, gl_budorg_bc_options bc
WHERE rng.ledger_id = x_ledger_id
AND rng.currency_code = x_funct_curr
AND bc.range_id = rng.range_id
AND bc.funds_check_level_code IN ('D', 'B')
AND bc.funding_budget_version_id = x_budget_version_id;
SELECT 'Summary Funding budget'
FROM gl_summary_templates sum, gl_summary_bc_options bc
WHERE sum.ledger_id = x_ledger_id
AND bc.template_id = sum.template_id
AND bc.funds_check_level_code IN ('D','B')
AND bc.funding_budget_version_id = x_budget_version_id;
SELECT 'Used as master'
FROM gl_budget_versions detail
WHERE detail.control_budget_version_id = budget_id;
SELECT status
FROM gl_budget_versions
WHERE budget_version_id = frozen_budget.budget_version_id;
SELECT frozen_flag
FROM gl_entity_budgets
WHERE budget_version_id = frozen_budget_entity.budget_version_id
AND budget_entity_id = frozen_budget_entity.budget_entity_id;
SELECT 'Frozen'
FROM gl_code_combinations cc, gl_budget_frozen_ranges bfr
WHERE bfr.budget_version_id = frozen_account.budget_version_id
AND bfr.budget_entity_id = entity_id
AND cc.code_combination_id = frozen_account.code_combination_id
AND cc.chart_of_accounts_id = frozen_account.coa_id
AND nvl(cc.segment1,'XXX') between nvl(bfr.segment1_low,'XXX')
and nvl(bfr.segment1_high,'XXX')
AND nvl(cc.segment2,'XXX') between nvl(bfr.segment2_low,'XXX')
and nvl(bfr.segment2_high,'XXX')
AND nvl(cc.segment3,'XXX') between nvl(bfr.segment3_low,'XXX')
and nvl(bfr.segment3_high,'XXX')
AND nvl(cc.segment4,'XXX') between nvl(bfr.segment4_low,'XXX')
and nvl(bfr.segment4_high,'XXX')
AND nvl(cc.segment5,'XXX') between nvl(bfr.segment5_low,'XXX')
and nvl(bfr.segment5_high,'XXX')
AND nvl(cc.segment6,'XXX') between nvl(bfr.segment6_low,'XXX')
and nvl(bfr.segment6_high,'XXX')
AND nvl(cc.segment7,'XXX') between nvl(bfr.segment7_low,'XXX')
and nvl(bfr.segment7_high,'XXX')
AND nvl(cc.segment8,'XXX') between nvl(bfr.segment8_low,'XXX')
and nvl(bfr.segment8_high,'XXX')
AND nvl(cc.segment9,'XXX') between nvl(bfr.segment9_low,'XXX')
and nvl(bfr.segment9_high,'XXX')
AND nvl(cc.segment10,'XXX') between nvl(bfr.segment10_low,'XXX')
and nvl(bfr.segment10_high,'XXX')
AND nvl(cc.segment11,'XXX') between nvl(bfr.segment11_low,'XXX')
and nvl(bfr.segment11_high,'XXX')
AND nvl(cc.segment12,'XXX') between nvl(bfr.segment12_low,'XXX')
and nvl(bfr.segment12_high,'XXX')
AND nvl(cc.segment13,'XXX') between nvl(bfr.segment13_low,'XXX')
and nvl(bfr.segment13_high,'XXX')
AND nvl(cc.segment14,'XXX') between nvl(bfr.segment14_low,'XXX')
and nvl(bfr.segment14_high,'XXX')
AND nvl(cc.segment15,'XXX') between nvl(bfr.segment15_low,'XXX')
and nvl(bfr.segment15_high,'XXX')
AND nvl(cc.segment16,'XXX') between nvl(bfr.segment16_low,'XXX')
and nvl(bfr.segment16_high,'XXX')
AND nvl(cc.segment17,'XXX') between nvl(bfr.segment17_low,'XXX')
and nvl(bfr.segment17_high,'XXX')
AND nvl(cc.segment18,'XXX') between nvl(bfr.segment18_low,'XXX')
and nvl(bfr.segment18_high,'XXX')
AND nvl(cc.segment19,'XXX') between nvl(bfr.segment19_low,'XXX')
and nvl(bfr.segment19_high,'XXX')
AND nvl(cc.segment20,'XXX') between nvl(bfr.segment20_low,'XXX')
and nvl(bfr.segment20_high,'XXX')
AND nvl(cc.segment21,'XXX') between nvl(bfr.segment21_low,'XXX')
and nvl(bfr.segment21_high,'XXX')
AND nvl(cc.segment22,'XXX') between nvl(bfr.segment22_low,'XXX')
and nvl(bfr.segment22_high,'XXX')
AND nvl(cc.segment23,'XXX') between nvl(bfr.segment23_low,'XXX')
and nvl(bfr.segment23_high,'XXX')
AND nvl(cc.segment24,'XXX') between nvl(bfr.segment24_low,'XXX')
and nvl(bfr.segment24_high,'XXX')
AND nvl(cc.segment25,'XXX') between nvl(bfr.segment25_low,'XXX')
and nvl(bfr.segment25_high,'XXX')
AND nvl(cc.segment26,'XXX') between nvl(bfr.segment26_low,'XXX')
and nvl(bfr.segment26_high,'XXX')
AND nvl(cc.segment27,'XXX') between nvl(bfr.segment27_low,'XXX')
and nvl(bfr.segment27_high,'XXX')
AND nvl(cc.segment28,'XXX') between nvl(bfr.segment28_low,'XXX')
and nvl(bfr.segment28_high,'XXX')
AND nvl(cc.segment29,'XXX') between nvl(bfr.segment29_low,'XXX')
and nvl(bfr.segment29_high,'XXX')
AND nvl(cc.segment30,'XXX') between nvl(bfr.segment30_low,'XXX')
and nvl(bfr.segment30_high,'XXX');
SELECT name
FROM gl_budget_entities
WHERE budget_entity_id = frozen_account.budget_entity_id;
SELECT budget_entity_id
FROM gl_budget_assignments
WHERE ledger_id = frozen_account.ledger_id AND
code_combination_id = frozen_account.code_combination_id AND
currency_code=frozen_account.currency_code;
SELECT frozen_flag
FROM gl_entity_budgets
WHERE budget_version_id=frozen_account.budget_version_id and budget_entity_id=entity_id;
SELECT meaning
FROM gl_lookups
WHERE lookup_type='LITERAL' AND lookup_code='ALL';
gl_budget_assignment_pkg.select_columns(lgr_id,
code_combination_id,
currency_code,
budget_entity_id,
entry_code);
gl_budget_entities_pkg.select_columns(budget_entity_id,
budget_entity,
password_flag,
encrypted_password,
status_code);
SELECT GL_BUDGET_FROZEN_RANGES_S.NEXTVAL
FROM dual;
SELECT prs.period_year,
prs.start_period_name,
prs.start_period_num,
pre.period_year,
pre.end_period_name,
pre.end_period_num
FROM gl_budget_period_ranges prs,
gl_budget_period_ranges pre
WHERE prs.budget_version_id = pre.budget_version_id
AND prs.budget_version_id = x_budget_version_id
AND prs.period_year * 100000 + prs.start_period_num =
(SELECT MIN(period_year * 100000 + start_period_num)
FROM gl_budget_period_ranges
WHERE budget_version_id = x_budget_version_id
AND open_flag = 'O')
AND pre.period_year * 100000 + pre.start_period_num =
(SELECT MAX(period_year * 100000 + start_period_num)
FROM gl_budget_period_ranges
WHERE budget_version_id = x_budget_version_id
AND open_flag = 'O');
SELECT period_year, period_num
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = X_Ledger_Id
AND period_num between 1 and 60
AND period_name = X_First_Valid_Period_Name;
SELECT period_year, period_num
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = X_Ledger_Id
AND period_num between 1 and 60
AND period_year * 10000 + period_num >=
p_first_valid_period_year * 10000 + p_first_valid_period_num
AND period_name = X_Last_Valid_Period_Name;
SELECT require_budget_journals_flag, currency_code, name
INTO v_rbj_flag, v_func_curr_code, v_ledger_name
FROM gl_ledgers
WHERE ledger_id = X_Ledger_Id;