APPS.IGI_GEN_VERT dependencies on IGI_GCC_GL_FA_INST_OPS

Line 20: FROM igi_gcc_gl_fa_inst_ops

16:
17: --Two queries seperated for bug3855184:Start
18: CURSOR Get_gl_fa_installed_option is
19: SELECT status_flag
20: FROM igi_gcc_gl_fa_inst_ops
21: WHERE option_name = upper(p_option_name) ;
22: --Two queries seperated for bug3855184:End
23:
24: v_installed_flag varchar2(1);

Line 62: FROM IGI_gcc_gl_fa_inst_ops

58:
59: --Two queries seperated for bug3855184:Start
60: CURSOR Get_gl_fa_installed_option is
61: (SELECT status_flag
62: FROM IGI_gcc_gl_fa_inst_ops
63: WHERE option_name = upper(p_option_name) ) ;
64: --Two queries seperated for bug3855184:End
65:
66: v_installed_flag varchar2(1);

Line 151: FROM IGI_gcc_gl_fa_inst_ops

147:
148: --Two queries seperated for bug3855184:Start
149: CURSOR gl_fa_stat_check is
150: (SELECT status_flag
151: FROM IGI_gcc_gl_fa_inst_ops
152: WHERE option_name = upper(p_option_name )) ;
153: --Two queries seperated for bug3855184:End
154:
155: BEGIN

Line 298: FROM igi_gcc_gl_fa_inst_ops

294: l_dummy VARCHAR2(1);
295:
296: CURSOR c_igi_install is
297: SELECT 'x'
298: FROM igi_gcc_gl_fa_inst_ops
299: WHERE status_flag = 'Y';
300:
301: BEGIN
302:

Line 337: FROM IGI_gcc_gl_fa_inst_ops

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
338: WHERE status_flag = 'Y');
339:
340: BEGIN
341:

Line 476: FROM IGI_gcc_gl_fa_inst_ops

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
477: WHERE status_flag = 'Y');
478:
479: BEGIN
480: