APPS.GL_FLEX_INSERT_PKG dependencies on DUAL

Line 359: from dual

355: --where code_combination_id = ccid;
356:
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'

Line 1841: from sys.dual;

1837: FUNCTION glfgdg RETURN BOOLEAN IS
1838:
1839: cursor dyngrp is
1840: select gl_dynamic_summ_combinations_s.NEXTVAL
1841: from sys.dual;
1842:
1843: -- ========================= FND LOG ===========================
1844: l_full_path VARCHAR2(100) := g_path || 'glfgdg.';
1845: -- ========================= FND LOG ===========================

Line 1863: add_message('FND', 'FLEX-NO ROWS IN DUAL');

1859: psa_utils.debug_other_string(g_state_level,l_full_path,' dyn_grp_id -> ' || dyn_grp_id);
1860: -- ========================= FND LOG ===========================
1861:
1862: if dyngrp%NOTFOUND then
1863: add_message('FND', 'FLEX-NO ROWS IN DUAL');
1864: -- ========================= FND LOG ===========================
1865: psa_utils.debug_other_string(g_state_level,l_full_path,' goto return_invalid ');
1866: -- ========================= FND LOG ===========================
1867: goto return_invalid;

Line 2991: from sys.dual;

2987: FUNCTION glfanc RETURN BOOLEAN IS
2988:
2989: cursor ccid_seq is
2990: select gl_code_combinations_s.NEXTVAL
2991: from sys.dual;
2992:
2993: -- ========================= FND LOG ===========================
2994: l_full_path VARCHAR2(100) := g_path || 'glfanc.';
2995: -- ========================= FND LOG ===========================

Line 3013: add_message('FND', 'FLEX-NO ROWS IN DUAL');

3009: psa_utils.debug_other_string(g_state_level,l_full_path,' min_ccid -> ' || min_ccid);
3010: -- ========================= FND LOG ===========================
3011:
3012: if ccid_seq%NOTFOUND then
3013: add_message('FND', 'FLEX-NO ROWS IN DUAL');
3014: -- ========================= FND LOG ===========================
3015: psa_utils.debug_other_string(g_state_level,l_full_path,' goto return_invalid');
3016: -- ========================= FND LOG ===========================
3017: goto return_invalid;