DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on GL_BUDGETS

Line 2968: LEFT OUTER JOIN gl_budgets b

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

Line 2994: LEFT OUTER JOIN gl_budgets b

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