APPS.IGS_GE_SEC_CONFIG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

     SELECT rowid
     FROM   igs_ge_cfg_form
     WHERE  responsibility_id = p_responsibility_id
     AND    form_code = p_form_name
     AND    NVL(query_only_ind,'N') = 'Y';

Line: 57

     SELECT TRIM(substr(tab_code,(instr(tab_code,'-')+1))) tab_code,config_opt
     FROM   igs_ge_cfg_tab_v
     WHERE  responsibility_id = p_responsibility_id
     AND    form_code = p_form_name;

Line: 94

  ||  gmaheswa     01/07/2004    Bug : 3294107 Modified cursor c_tab_exists to select row_id instead of rowid
  ||  pkpatel      01/08/2003    Bug : 3294107 Added the check config_opt = 'H'
  */

     CURSOR c_tab_exists IS
     SELECT row_id
     FROM   igs_ge_cfg_tab_v
     WHERE  responsibility_id = p_responsibility_id
     AND    form_code = p_form_name
     AND    TRIM(substr(tab_code,(instr(tab_code,'-')+1))) = TRIM(p_tab_name)
	 AND    config_opt = 'H';