APPS.PQH_GL_POSTING dependencies on GL_BUDGET_VERSIONS

Line 372: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;

368: l_budgets_rec pqh_budgets%ROWTYPE;
369: l_budget_versions_rec pqh_budget_versions%ROWTYPE;
370: l_gl_sets_of_books_rec gl_sets_of_books%ROWTYPE;
371: l_shared_types_rec per_shared_types%ROWTYPE;
372: l_gl_budget_versions_rec gl_budget_versions%ROWTYPE;
373: l_gl_je_sources_rec gl_je_sources%ROWTYPE;
374: l_gl_je_categories_rec gl_je_categories%ROWTYPE;
375: l_transfer_to_gl_flag varchar2(10);
376: l_message_text pqh_process_log.message_text%TYPE;

Line 422: FROM gl_budget_versions

418: --now select GL Budget Name from Budget Charectaristics form
419:
420: CURSOR csr_gl_budget_version (p_gl_budget_name IN varchar2) IS
421: SELECT *
422: FROM gl_budget_versions
423: WHERE budget_name = p_gl_budget_name AND
424: status in ('O','C');
425:
426: CURSOR csr_gl_je_sources IS

Line 650: FETCH csr_gl_budget_version INTO l_gl_budget_versions_rec;

646: END IF; -- count <> 0 i.e mapping is defined
647:
648: -- get gl_budget_version_id
649: OPEN csr_gl_budget_version(p_gl_budget_name => l_gl_budget_name);
650: FETCH csr_gl_budget_version INTO l_gl_budget_versions_rec;
651: CLOSE csr_gl_budget_version;
652:
653: g_gl_budget_version_id := l_gl_budget_versions_rec.budget_version_id;
654:

Line 653: g_gl_budget_version_id := l_gl_budget_versions_rec.budget_version_id;

649: OPEN csr_gl_budget_version(p_gl_budget_name => l_gl_budget_name);
650: FETCH csr_gl_budget_version INTO l_gl_budget_versions_rec;
651: CLOSE csr_gl_budget_version;
652:
653: g_gl_budget_version_id := l_gl_budget_versions_rec.budget_version_id;
654:
655: -- CHECK : if gl_budget_version_id exists else error
656: IF g_gl_budget_version_id IS NULL THEN
657: -- get message text for PQH_GL_BUDGET_INVALID