APPS.PQH_COMMITMENT_POSTING dependencies on PQH_BUDGET_GL_FLEX_MAPS

Line 386: FROM pqh_budget_gl_flex_maps

382: WHERE table_alias = p_table_alias;
383:
384: CURSOR csr_flex_maps_counts (p_budget_id IN number)IS
385: SELECT COUNT(*)
386: FROM pqh_budget_gl_flex_maps
387: WHERE budget_id = p_budget_id;
388:
389: CURSOR csr_cost_map_null (p_budget_id IN number) IS
390: SELECT COUNT(*)

Line 391: FROM pqh_budget_gl_flex_maps

387: WHERE budget_id = p_budget_id;
388:
389: CURSOR csr_cost_map_null (p_budget_id IN number) IS
390: SELECT COUNT(*)
391: FROM pqh_budget_gl_flex_maps
392: WHERE budget_id = p_budget_id
393: AND payroll_cost_segment IS NULL;
394:
395: cursor csr_gl_encumbrance_types is

Line 662: -- check if rows in pqh_budget_gl_flex_maps with NULL cost segments

658: END IF;
659:
660: END IF;
661: Else
662: -- check if rows in pqh_budget_gl_flex_maps with NULL cost segments
663: OPEN csr_cost_map_null(p_budget_id => g_budget_id);
664: FETCH csr_cost_map_null INTO l_map_count_null;
665: CLOSE csr_cost_map_null;
666: