[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT segment_num, application_column_name
FROM fnd_id_flex_segments
WHERE application_id = 101
AND id_flex_code = 'GL#'
AND enabled_flag = 'Y'
AND id_flex_num = x_chart_of_accounts_id
ORDER BY segment_num;
SELECT
chart_of_accounts_id,
name,
short_name,
currency_code,
period_set_name,
accounted_period_type,
suspense_allowed_flag,
allow_intercompany_post_flag,
require_budget_journals_flag,
enable_budgetary_control_flag,
latest_opened_period_name,
latest_encumbrance_year,
future_enterable_periods_limit,
cum_trans_code_combination_id,
ret_earn_code_combination_id,
res_encumb_code_combination_id,
enable_average_balances_flag,
transaction_calendar_id,
net_income_code_combination_id,
consolidation_sob_flag,
daily_translation_rate_type,
enable_automatic_tax_flag,
mrc_sob_type_code,
enable_je_approval_flag
FROM
GL_SETS_OF_BOOKS
WHERE
set_of_books_id = X_set_of_books_id;
SELECT nvl(multi_org_flag, 'N')
FROM fnd_product_groups;
gl_iea_subsidiary_pkg.select_columns(
x_subsidiary_id,
x_name,
x_chart_of_accounts_id,
x_set_of_books_id,
x_enabled_flag,
x_subsidiary_type_code,
x_company_value,
x_currency_code,
x_autoapprove_flag,
x_view_partner_lines_flag,
x_conversion_type_code,
x_conversion_type,
x_remote_instance_flag,
x_transfer_set_of_books_id,
x_transfer_currency_code,
x_contact,
x_notification_threshold);
gl_system_usages_pkg.select_columns(x_average_balances_flag,
x_consolidation_ledger_flag);
SELECT 'x' INTO dummy
FROM gl_iea_subsidiaries
WHERE subsidiary_id = X_Subsidiary_Id
AND enabled_flag = 'Y';