APPS.XLA_JE_VALIDATION_PKG dependencies on GL_BUDGET_VERSIONS

Line 3241: LEFT OUTER JOIN gl_budget_versions bv

3237: JOIN gl_period_statuses gp
3238: ON gp.period_name = h.period_name
3239: AND gp.ledger_id = g_ledger_id
3240: AND gp.application_id = C_GL_APPLICATION_ID
3241: LEFT OUTER JOIN gl_budget_versions bv
3242: ON bv.budget_version_id = h.budget_version_id
3243: LEFT OUTER JOIN gl_budgets b
3244: ON b.budget_name = bv.budget_name
3245: AND b.budget_type = bv.budget_type

Line 3267: LEFT OUTER JOIN gl_budget_versions bv

3263: h.period_year > b.latest_opened_year
3264: THEN 'N'
3265: ELSE 'Y' END budget_period_valid_flag
3266: FROM xla_ae_headers_gt h
3267: LEFT OUTER JOIN gl_budget_versions bv
3268: ON bv.budget_version_id = h.budget_version_id
3269: LEFT OUTER JOIN gl_budgets b
3270: ON b.budget_name = bv.budget_name
3271: AND b.budget_type = bv.budget_type

Line 3369: FROM gl_budget_versions

3365:
3366: ELSIF (l_err.budget_period_valid_flag = 'N') THEN
3367: SELECT budget_name
3368: INTO l_budget_name
3369: FROM gl_budget_versions
3370: WHERE budget_version_id = l_err.budget_version_id;
3371:
3372: xla_accounting_err_pkg.build_message(
3373: p_appli_s_name => 'XLA'

Line 4478: JOIN gl_budget_versions bud

4474: ,t.entity_id
4475: ,bud.budget_name
4476: ,fnd_flex_ext.get_segs('SQLGL', 'GL#', t.ccid_coa_id, t.code_combination_id) account
4477: FROM xla_validation_lines_gt t
4478: JOIN gl_budget_versions bud
4479: ON bud.budget_version_id = t.budget_version_id
4480: LEFT OUTER JOIN gl_budget_assignments b
4481: ON b.currency_code = t.entered_currency_code
4482: AND b.code_combination_id = t.code_combination_id

Line 4715: FROM gl_budget_versions

4711: AND amb_context_code = g_amb_context_code;
4712:
4713: CURSOR c_budget_name(p_budget_version_id INTEGER) IS
4714: SELECT budget_name
4715: FROM gl_budget_versions
4716: WHERE budget_version_id = p_budget_version_id;
4717:
4718: CURSOR c_user_conv_type(p_conv_type VARCHAR2) IS
4719: SELECT gdct.user_conversion_type