APPS.GL_FLEX_INSERT_PKG dependencies on GL_ACCOUNT_HIERARCHIES

Line 262: /* GL_ACCOUNT_HIERARCHIES */

258: /* GL_SUMMARY_TEMPLATES */
259: /* GL_DYNAMIC_SUMM_COMBINATIONS */
260: /* GL_ROLLUP_GROUP_SCORES */
261: /* GL_CONCURRENCY_CONTROL */
262: /* GL_ACCOUNT_HIERARCHIES */
263: /* */
264: /* AOL Tables which are being used include : */
265: /* */
266: /* FND_ID_FLEX_SEGMENTS */

Line 361: from gl_account_hierarchies

357: BEGIN
358: select 'Y' into l_temp_var
359: from dual
360: where not exists (select 'x'
361: from gl_account_hierarchies
362: where detail_code_combination_id = ccid)
363: and not exists (select 'x'
364: from gl_budget_assignments
365: where code_combination_id = ccid);

Line 589: -- (5) maintain gl_account_hierarchies

585: -- (1) lock the summary templates that have parent accounts created
586: -- (2) find ccids for existing parents
587: -- (3) assign new ccids to new parents
588: -- (4) insert the newly created parents into gl_code_combinations
589: -- (5) maintain gl_account_hierarchies
590:
591: if created_parent then
592:
593: -- ========================= FND LOG ===========================

Line 3278: sql_acchy := 'insert into gl_account_hierarchies (' ||

3274: -- ========================= FND LOG ===========================
3275: psa_utils.debug_other_string(g_state_level,l_full_path,' START glfmah ');
3276: -- ========================= FND LOG ===========================
3277:
3278: sql_acchy := 'insert into gl_account_hierarchies (' ||
3279: 'ledger_id, ' ||
3280: 'summary_code_combination_id, ' ||
3281: 'detail_code_combination_id, ' ||
3282: 'template_id, ' ||

Line 3299: 'from gl_account_hierarchies ah ' ||

3295: 'from gl_dynamic_summ_combinations dsc ' ||
3296: 'where dsc.dynamic_group_id = :grp_id ' ||
3297: 'and not exists (' ||
3298: 'select 1 ' ||
3299: 'from gl_account_hierarchies ah ' ||
3300: 'where ah.summary_code_combination_id = ' ||
3301: 'dsc.code_combination_id ' ||
3302: 'and ah.detail_code_combination_id = :ccid)';
3303: