APPS.IGS_GE_GEN_004 SQL Statements

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

Line: 20

FUNCTION GENP_GET_WHO_NAME(p_last_updated_by   IN NUMBER)
RETURN VARCHAR2 IS
   CURSOR c_user_name is
                   SELECT user_name
                   FROM   fnd_user
                   WHERE  user_id=p_last_updated_by;

Line: 48

                   SELECT meaning
                   FROM   IGS_LOOKUP_VALUES
                   WHERE lookup_type=cp_lookup_type        AND
                         lookup_code=cp_lookup_code;

Line: 89

		SELECT	*
		FROM	IGS_PE_STD_TODO
		WHERE	person_id = p_person_id						AND
				s_student_todo_type = p_s_student_todo_type	AND
				sequence_number = p_sequence_number
		FOR UPDATE
		NOWAIT;

Line: 97

		SELECT IGS_PE_STD_TODO.* , ROWID
		FROM IGS_PE_STD_TODO
		WHERE	person_id = p_person_id						AND
		s_student_todo_type = p_s_student_todo_type	AND
		sequence_number = p_sequence_number;

Line: 105

	-- Update the IGS_PE_STD_TODO  table with the NOWAIT option.
	OPEN c_lock_st_records;

Line: 110

	IGS_PE_STD_TODO_PKG.UPDATE_ROW(
		x_rowid => SI_RE_REC.ROWID ,
		X_PERSON_ID  => SI_RE_REC.PERSON_ID,
		X_S_STUDENT_TODO_TYPE => SI_RE_REC.S_STUDENT_TODO_TYPE,
		X_SEQUENCE_NUMBER => SI_RE_REC.SEQUENCE_NUMBER,
		X_TODO_DT => SI_RE_REC.TODO_DT,
		X_LOGICAL_DELETE_DT => SYSDATE ,
		X_MODE=> 'R'
	);

Line: 147

SELECT
	'x'
FROM	IGS_CO_ADDR_TYPE adt
WHERE	adt.addr_type 		=	cp_addr_type;

Line: 248

      SELECT    meaning
      FROM      fnd_lookups
      WHERE     lookup_type = 'DAY_NAME'
      AND       lookup_code = cp_day_short_name;

Line: 275

      SELECT TO_CHAR(decode(sign(to_number(P_NUMBER )),-1,0,to_number(P_NUMBER))) into l from dual;

Line: 286

         SELECT us_out.abbreviation, us_out.short_title, us_out.title
	 FROM   igs_en_unit_set us_out
	 WHERE  us_out.unit_set_cd = cp_unit_set_cd
	 AND    us_out.version_number = (SELECT version_number
                                  FROM   igs_en_unit_set us_in ,
                                         igs_en_unit_set_stat uss
			          WHERE uss.unit_set_status = us_in.unit_set_status
				  AND   us_in.unit_set_cd = us_out.unit_set_cd
                                  AND   uss.s_unit_set_status = 'ACTIVE'
			          AND   rownum = 1);

Line: 299

         SELECT wif_unit_set_title
	 FROM   igs_da_setup
	 WHERE  s_control_num = 1;