DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on GL_BUDGETS

Line 3243: LEFT OUTER JOIN gl_budgets b

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
3246: WHERE h.ae_header_id = g_ae_header_id
3247: AND h.application_id = g_application_id

Line 3269: LEFT OUTER JOIN gl_budgets b

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
3272: WHERE h.ledger_id = g_ledger_id
3273: AND h.balance_type_code = 'B'