DBA Data[Home] [Help]

APPS.GL_SUMMARY_BC_OPTIONS_PKG dependencies on GL_PERIOD_STATUSES

Line 30: gl_period_statuses pf1,

26: (SELECT 'X'
27: FROM gl_budgets b1,
28: gl_budget_versions bv1,
29: gl_summary_bc_options sa,
30: gl_period_statuses pf1,
31: gl_period_statuses pl1,
32: gl_budgets b2,
33: gl_budget_versions bv2,
34: gl_period_statuses pf2,

Line 31: gl_period_statuses pl1,

27: FROM gl_budgets b1,
28: gl_budget_versions bv1,
29: gl_summary_bc_options sa,
30: gl_period_statuses pf1,
31: gl_period_statuses pl1,
32: gl_budgets b2,
33: gl_budget_versions bv2,
34: gl_period_statuses pf2,
35: gl_period_statuses pl2

Line 34: gl_period_statuses pf2,

30: gl_period_statuses pf1,
31: gl_period_statuses pl1,
32: gl_budgets b2,
33: gl_budget_versions bv2,
34: gl_period_statuses pf2,
35: gl_period_statuses pl2
36: WHERE b1.current_version_id = bv1.version_num
37: AND b1.budget_name = bv1.budget_name
38: AND bv1.budget_version_id = sa.funding_budget_version_id

Line 35: gl_period_statuses pl2

31: gl_period_statuses pl1,
32: gl_budgets b2,
33: gl_budget_versions bv2,
34: gl_period_statuses pf2,
35: gl_period_statuses pl2
36: WHERE b1.current_version_id = bv1.version_num
37: AND b1.budget_name = bv1.budget_name
38: AND bv1.budget_version_id = sa.funding_budget_version_id
39: AND b1.first_valid_period_name = pf1.period_name