APPS.IGS_EN_VAL_PDI SQL Statements

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

Line: 14

  		SELECT	'x'
  		FROM	IGS_PE_PERS_DISABLTY pdi,
  			IGS_AD_DISBL_TYPE dit
  		WHERE	pdi.person_id	= p_person_id AND
  			dit.disability_type	= pdi.disability_type AND
  			dit.govt_disability_type	= cst_NONE AND
  			EXISTS	(
  				SELECT	'x'
  				FROM	IGS_PE_PERS_DISABLTY pdi1,
  					IGS_AD_DISBL_TYPE dit1
  				WHERE	pdi1.person_id	= p_person_id AND
  					dit1.disability_type	= pdi1.disability_type AND
  					dit1.govt_disability_type	 <>  cst_NONE
  				);

Line: 74

  		SELECT	govt_disability_type
  		FROM	IGS_AD_DISBL_TYPE	dit
  		WHERE	dit.disability_type = p_disability_type;

Line: 120

  		SELECT	closed_ind
  		FROM	IGS_AD_DISBL_TYPE
  		WHERE	disability_type = p_disability_type;