APPS.IGI_GEN_VERT dependencies on IGI_GCC_INSTALLED_OPTIONS

Line 13: FROM igi_gcc_installed_options

9: IS
10: CURSOR Get_installed_option
11: is
12: SELECT status_flag
13: FROM igi_gcc_installed_options
14: WHERE option_name = upper(p_option_name)
15: AND org_id = p_org_id;
16:
17: --Two queries seperated for bug3855184:Start

Line 56: FROM IGI_gcc_installed_options

52:
53:
54: CURSOR get_installed_option is
55: (SELECT status_flag
56: FROM IGI_gcc_installed_options
57: WHERE option_name = upper(p_option_name) );
58:
59: --Two queries seperated for bug3855184:Start
60: CURSOR Get_gl_fa_installed_option is

Line 145: FROM IGI_gcc_installed_options

141: IS
142:
143: CURSOR stat_check IS
144: (SELECT status_flag
145: FROM IGI_gcc_installed_options
146: WHERE option_name = upper(p_option_name ));
147:
148: --Two queries seperated for bug3855184:Start
149: CURSOR gl_fa_stat_check is

Line 333: FROM IGI_gcc_installed_options

329: l_ErrMsg VARCHAR2(2000);
330:
331: CURSOR c_install_option is
332: (SELECT option_name
333: FROM IGI_gcc_installed_options
334: WHERE status_flag = 'Y')
335: UNION
336: (SELECT option_name
337: FROM IGI_gcc_gl_fa_inst_ops

Line 472: FROM IGI_gcc_installed_options

468: l_ErrMsg VARCHAR2(2000);
469:
470: CURSOR c_install_option is
471: (SELECT option_name
472: FROM IGI_gcc_installed_options
473: WHERE status_flag = 'Y')
474: UNION
475: (SELECT option_name
476: FROM IGI_gcc_gl_fa_inst_ops