APPS.GL_BUDGET_UTILS_PKG dependencies on GL_BUDGET_VERSIONS

Line 16: FROM gl_budgets b, gl_budget_versions bv

12:
13: CURSOR chk_budget IS
14: SELECT bv.budget_version_id, b.budget_name,
15: b.require_budget_journals_flag
16: FROM gl_budgets b, gl_budget_versions bv
17: WHERE b.ledger_id = x_ledger_id
18: AND b.status = 'C'
19: AND bv.budget_name = b.budget_name
20: AND bv.budget_type = b.budget_type;

Line 72: FROM gl_budget_versions detail

68: RETURN BOOLEAN IS
69:
70: CURSOR chk_master IS
71: SELECT 'Used as master'
72: FROM gl_budget_versions detail
73: WHERE detail.control_budget_version_id = budget_id;
74: dummy VARCHAR2(100);
75: BEGIN
76: OPEN chk_master;

Line 91: FROM gl_budget_versions

87:
88: FUNCTION frozen_budget(budget_version_id NUMBER) RETURN BOOLEAN IS
89: CURSOR chk_frozen IS
90: SELECT status
91: FROM gl_budget_versions
92: WHERE budget_version_id = frozen_budget.budget_version_id;
93: tmp_status VARCHAR2(1);
94: BEGIN
95: OPEN chk_frozen;