APPS.IGS_AD_GRD_DATA_LOAD SQL Statements

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

Line: 79

     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: 677

     SELECT	1
     FROM 	IGS_AD_AUS_SEC_ED_SU ases
     WHERE 	ases.person_id		 = G_current_person_id and
                ases.ase_sequence_number = ase_sequence_number and
		ases.subject_result_yr 	= sub_result_yr and
		ases.subject_cd		= vtac_subject_code;

Line: 736

	    -- This procedure inserts a new aus_scndry_education record
		IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_AUS_SCN_EDU(
					G_current_person_id,
					result_yr,
					score,
					vtac_state_name,
					NULL,
					vtac_qual_type,
					vtac_qual_school,
					ase_sequence_number,	-- OUT NOCOPY
					v_message_name) = FALSE
			THEN
			G_message_str := FND_MESSAGE.GET_STRING('IGS',v_message_name);

Line: 807

	        	 -- Insert an Australian secondary education subject record
		        IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_AUS_SCN_SUB(
						G_current_person_id,
				  		ase_sequence_number,
						sub_result_yr,
						vtac_subject_code,
						NULL,
						sub_result,
						NULL,
						NULL,
						vtac_subject_type,
						NULL,
						v_message_name) = FALSE
		            THEN
                           G_message_str :=FND_MESSAGE.GET_STRING('IGS',v_message_name);

Line: 886

	v_inserted_ind		VARCHAR2(1);

Line: 983

				v_inserted_ind) = FALSE	THEN

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

Line: 1080

				v_inserted_ind) = FALSE)	THEN

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