APPS.IGS_AD_PG_DATA_LOAD SQL Statements

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

Line: 71

     	SELECT  pe_person_id
          FROM  IGS_PE_ALT_PERS_ID
         WHERE  api_person_id = cp_api_person_id
           AND  person_id_type = cp_alt_person_id_type
           AND  start_dt < SYSDATE
           AND  NVL(end_dt,SYSDATE) >= SYSDATE;

Line: 532

	 --   Get the data we need for inserting an admission_appl
         IF  p_override_adm_cat  IS NOT NULL THEN
              admission_cat  :=  p_override_adm_cat;

Line: 597

		--There must have been an error inserting
	     FND_FILE.PUT_LINE( FND_FILE.LOG,FND_MESSAGE.GET_STRING('IGS','IGS_AD_ERR_APPLICANT')||' '|| G_pg_current_person_id||' '||course_cd||'-'||G_pg_message_str);

Line: 652

	v_inserted_ind  		VARCHAR2(1);

Line: 730

				v_inserted_ind) = FALSE	THEN

				G_pg_message_str := FND_MESSAGE.GET_STRING('IGS', v_message_name);