APPS.XLA_JE_VALIDATION_PKG dependencies on GL_BUDGET_VERSIONS

Line 2966: LEFT OUTER JOIN gl_budget_versions bv

2962: JOIN gl_period_statuses gp
2963: ON gp.period_name = h.period_name
2964: AND gp.ledger_id = g_ledger_id
2965: AND gp.application_id = C_GL_APPLICATION_ID
2966: LEFT OUTER JOIN gl_budget_versions bv
2967: ON bv.budget_version_id = h.budget_version_id
2968: LEFT OUTER JOIN gl_budgets b
2969: ON b.budget_name = bv.budget_name
2970: AND b.budget_type = bv.budget_type

Line 2992: LEFT OUTER JOIN gl_budget_versions bv

2988: h.period_year > b.latest_opened_year
2989: THEN 'N'
2990: ELSE 'Y' END budget_period_valid_flag
2991: FROM xla_ae_headers_gt h
2992: LEFT OUTER JOIN gl_budget_versions bv
2993: ON bv.budget_version_id = h.budget_version_id
2994: LEFT OUTER JOIN gl_budgets b
2995: ON b.budget_name = bv.budget_name
2996: AND b.budget_type = bv.budget_type

Line 3094: FROM gl_budget_versions

3090:
3091: ELSIF (l_err.budget_period_valid_flag = 'N') THEN
3092: SELECT budget_name
3093: INTO l_budget_name
3094: FROM gl_budget_versions
3095: WHERE budget_version_id = l_err.budget_version_id;
3096:
3097: xla_accounting_err_pkg.build_message(
3098: p_appli_s_name => 'XLA'

Line 4191: JOIN gl_budget_versions bud

4187: ,t.entity_id
4188: ,bud.budget_name
4189: ,fnd_flex_ext.get_segs('SQLGL', 'GL#', t.ccid_coa_id, t.code_combination_id) account
4190: FROM xla_validation_lines_gt t
4191: JOIN gl_budget_versions bud
4192: ON bud.budget_version_id = t.budget_version_id
4193: LEFT OUTER JOIN gl_budget_assignments b
4194: ON b.currency_code = t.entered_currency_code
4195: AND b.code_combination_id = t.code_combination_id

Line 4426: FROM gl_budget_versions

4422: AND amb_context_code = g_amb_context_code;
4423:
4424: CURSOR c_budget_name(p_budget_version_id INTEGER) IS
4425: SELECT budget_name
4426: FROM gl_budget_versions
4427: WHERE budget_version_id = p_budget_version_id;
4428:
4429: CURSOR c_user_conv_type(p_conv_type VARCHAR2) IS
4430: SELECT gdct.user_conversion_type