APPS.IGS_PE_VAL_PIGS SQL Statements

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

Line: 14

  	--  insert, update and delete IGS_PE_PERSON ID Group Security records.
  DECLARE
  	v_creator_person_id	NUMBER;

Line: 21

		SELECT pig.creator_person_id
		FROM IGS_PE_PERSID_GROUP_ALL pig, igs_pe_hz_parties pe, hz_parties hp
		WHERE pig.group_id  = p_group_id AND
		pig.creator_person_id = hp.party_id AND
		hp.party_id = pe.party_id (+) AND
		pig.creator_person_id = pe.party_id AND
		(pe.oracle_username = fnd_global.user_name OR pe.oracle_username IS NULL);

Line: 38

  	-- The group_creator has full insert/update/delete priviledges.
  	OPEN c_pig;