APPS.IGS_FI_VAL_PFE SQL Statements

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

Line: 30

  		SELECT	et.s_encumbrance_cat
  		FROM	IGS_FI_ENCMB_TYPE		et
  		WHERE	et.encumbrance_type		= cp_encumbrance_type;

Line: 37

  		SELECT	'x'
  		FROM	IGS_PE_PERS_ENCUMB	pe
  		WHERE	pe.person_id		=  cp_person_id AND
  			pe.encumbrance_type	=  cp_encumbrance_type AND
  			trunc(pe.start_dt) <=
  				trunc(cp_fee_encumbrance_dt) AND
  			(pe.expiry_dt IS NULL OR
  			 trunc(pe.expiry_dt) >
  			trunc(cp_fee_encumbrance_dt));

Line: 50

  		SELECT	'x'
  		FROM	IGS_PE_PERS_ENCUMB	pe
  		WHERE	pe.person_id		= cp_person_id AND
  			pe.ENCUMBRANCE_TYPE	= cp_encumbrance_type AND
  			trunc(pe.start_dt)= trunc(cp_start_dt);