25: (SELECT 'X'
26: FROM gl_budgets b1,
27: gl_budget_versions bv1,
28: gl_budorg_bc_options ba,
29: gl_period_statuses pf1,
30: gl_period_statuses pl1,
31: gl_budgets b2,
32: gl_budget_versions bv2,
33: gl_period_statuses pf2,
26: FROM gl_budgets b1,
27: gl_budget_versions bv1,
28: gl_budorg_bc_options ba,
29: gl_period_statuses pf1,
30: gl_period_statuses pl1,
31: gl_budgets b2,
32: gl_budget_versions bv2,
33: gl_period_statuses pf2,
34: gl_period_statuses pl2
29: gl_period_statuses pf1,
30: gl_period_statuses pl1,
31: gl_budgets b2,
32: gl_budget_versions bv2,
33: gl_period_statuses pf2,
34: gl_period_statuses pl2
35: WHERE b1.current_version_id = bv1.version_num
36: AND b1.budget_name = bv1.budget_name
37: AND bv1.budget_version_id = ba.funding_budget_version_id
30: gl_period_statuses pl1,
31: gl_budgets b2,
32: gl_budget_versions bv2,
33: gl_period_statuses pf2,
34: gl_period_statuses pl2
35: WHERE b1.current_version_id = bv1.version_num
36: AND b1.budget_name = bv1.budget_name
37: AND bv1.budget_version_id = ba.funding_budget_version_id
38: AND b1.first_valid_period_name = pf1.period_name