APPS.PQH_COMMITMENT_POSTING dependencies on GL_BUDGET_VERSIONS

Line 315: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;

311: l_budget_versions_rec pqh_budget_versions%ROWTYPE;
312: --
313: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
314: l_shared_types_rec per_shared_types%ROWTYPE;
315: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
316: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
317: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
318: --
319: --

Line 365: FROM gl_budget_versions

361: --now select GL Budget Name from Budget Charectaristics form
362:
363: CURSOR csr_gl_budget_version (p_gl_budget_name IN varchar2) IS
364: SELECT *
365: FROM gl_budget_versions
366: WHERE budget_name =p_gl_budget_name AND
367: status in ('O','C');
368:
369: CURSOR csr_gl_je_sources IS

Line 729: FETCH csr_gl_budget_version INTO l_gl_budget_versions_rec;

725: --
726: -- get gl_budget_version_id
727: --
728: OPEN csr_gl_budget_version(p_gl_budget_name => l_gl_budget_name);
729: FETCH csr_gl_budget_version INTO l_gl_budget_versions_rec;
730: CLOSE csr_gl_budget_version;
731: --
732: g_gl_budget_version_id := l_gl_budget_versions_rec.budget_version_id;
733: --

Line 732: g_gl_budget_version_id := l_gl_budget_versions_rec.budget_version_id;

728: OPEN csr_gl_budget_version(p_gl_budget_name => l_gl_budget_name);
729: FETCH csr_gl_budget_version INTO l_gl_budget_versions_rec;
730: CLOSE csr_gl_budget_version;
731: --
732: g_gl_budget_version_id := l_gl_budget_versions_rec.budget_version_id;
733: --
734: -- CHECK : if gl_budget_version_id exists else error
735: --
736: IF g_gl_budget_version_id IS NULL THEN