DBA Data[Home] [Help]

APPS.GL_BUDORG_BC_OPTIONS_PKG dependencies on GL_PERIOD_STATUSES

Line 29: gl_period_statuses pf1,

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,

Line 30: gl_period_statuses pl1,

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

Line 33: gl_period_statuses pf2,

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

Line 34: gl_period_statuses pl2

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