APPS.IGS_ST_GEN_002 SQL Statements

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

Line: 32

		SELECT	cty.govt_course_type
		FROM	IGS_PS_VER 	cv,
			IGS_PS_TYPE 	cty
		WHERE	cv.course_cd		= p_course_cd AND
			cv.version_number	= p_version_number AND
			cty.course_type		= cv.course_type;

Line: 102

		SELECT	crfc.reference_cd,
			crfc.description
		FROM	IGS_PS_REF_CD	crfc,
			IGS_GE_REF_CD_TYPE	rct
		WHERE	crfc.course_cd		= p_course_cd AND
			crfc.version_number	= p_version_number AND
			rct.reference_cd_type	= crfc.reference_cd_type AND
			rct.s_reference_cd_type	= 'OTHER' AND
			rct.closed_ind		= 'N';

Line: 112

		SELECT	crv.title
		FROM	IGS_PS_VER	crv
		WHERE	crv.course_cd		= p_course_cd AND
			crv.version_number	= p_version_number;

Line: 191

		SELECT 	gslov.govt_semester
		FROM	IGS_ST_GVTSEMLOAD_OV gslov
		WHERE	gslov.submission_yr      = p_submission_yr 	    AND
			gslov.submission_number  = p_submission_number 	    AND
			gslov.cal_type 	        = p_load_cal_type  	    AND
			gslov.ci_sequence_number = p_load_ci_sequence_number AND
			gslov.teach_cal_type 	= p_teach_cal_type;

Line: 199

		SELECT 	gslc.govt_semester
		FROM	IGS_ST_GVTSEMLOAD_CA gslc
		WHERE	gslc.submission_yr      = p_submission_yr 	    AND
			gslc.submission_number  = p_submission_number 	    AND
			gslc.cal_type 	        = p_load_cal_type  	    AND
			gslc.ci_sequence_number = p_load_ci_sequence_number;

Line: 252

		SELECT	ps.prior_post_grad,
			ps.prior_degree,
			ps.prior_subdeg_notafe
		FROM	IGS_PE_STATISTICS	ps
		WHERE	ps.person_id 	= p_person_id AND
			TRUNC(ps.start_dt) <= TRUNC(SYSDATE) AND
			(ps.end_dt 	IS NULL OR
			TRUNC(ps.end_dt) >= TRUNC(SYSDATE))
		ORDER BY end_dt;

Line: 331

		SELECT	pe.birth_dt,
			pe.sex
		FROM	IGS_PE_PERSON		pe
		WHERE	pe.person_id	= p_person_id;

Line: 336

		SELECT	ps.aborig_torres_cd,
			ps.citizenship_cd,
			ps.birth_country_cd,
			ps.yr_arrival,
			ps.home_language_cd
		FROM	IGS_PE_STATISTICS	ps
		WHERE	ps.person_id		= p_person_id AND
			TRUNC(ps.start_dt)	<= TRUNC(p_effective_dt)
		ORDER BY ps.start_dt DESC;

Line: 350

		SELECT	atc.govt_aborig_torres_cd
		FROM	IGS_PE_ABORG_TORESCD	atc
		WHERE	atc.aborig_torres_cd	= v_aborig_torres_cd;

Line: 354

		SELECT	cic.govt_citizenship_cd
		FROM	IGS_ST_CITIZENSHP_CD		cic
		WHERE	cic.citizenship_cd	= v_citizenship_cd;

Line: 358

		SELECT	cnc.govt_country_cd
		FROM	IGS_PE_COUNTRY_CD	cnc
		WHERE	cnc.country_cd	= v_birth_country_cd;

Line: 362

		SELECT	lc.govt_language_cd
		FROM	IGS_PE_LANGUAGE_CD	lc
		WHERE	lc.language_cd	= v_home_language_cd;

Line: 542

		SELECT	pe.birth_dt,
			pe.sex
		FROM	IGS_PE_PERSON pe
		WHERE	pe.person_id = p_person_id;

Line: 547

		SELECT	ps.aborig_torres_cd,
			ps.citizenship_cd,
			ps.perm_resident_cd,
			ps.home_location_postcode,
			ps.home_location_country,
			ps.term_location_postcode,
			ps.term_location_country,
			ps.birth_country_cd,
			ps.yr_arrival,
			ps.home_language_cd,
			ps.prior_ug_inst,
			ps.prior_other_qual,
			ps.prior_post_grad,
			ps.prior_degree,
			ps.prior_subdeg_notafe,
			ps.prior_subdeg_tafe,
			ps.prior_seced_tafe,
			ps.prior_seced_school,
			ps.prior_tafe_award
		FROM	IGS_PE_STATISTICS ps
		WHERE	ps.person_id = p_person_id AND
			ps.start_dt <= p_effective_dt AND
			(ps.end_dt IS NULL OR
		 	ps.end_dt >= p_effective_dt)
		ORDER BY ps.end_dt ASC;

Line: 573

		SELECT 	atcd.govt_aborig_torres_cd
		FROM   	IGS_PE_ABORG_TORESCD atcd
		WHERE	atcd.aborig_torres_cd = v_aborig_torres_cd;

Line: 577

		SELECT 	ccd.govt_citizenship_cd
		FROM   	IGS_ST_CITIZENSHP_CD ccd
		WHERE	ccd.citizenship_cd = v_citizenship_cd;

Line: 582

		SELECT 	prcd.govt_perm_resident_cd
		FROM   	IGS_PE_PERM_RES_CD prcd
		WHERE	prcd.perm_resident_cd = cp_perm_res_cd;

Line: 587

		SELECT 	ccd.govt_country_cd
		FROM	IGS_PE_COUNTRY_CD ccd
		WHERE	ccd.country_cd = cp_country_cd;

Line: 592

		SELECT 	lcd.govt_language_cd
		FROM	IGS_PE_LANGUAGE_CD lcd
		WHERE	lcd.language_cd = cp_language_cd;

Line: 597

		SELECT 	inst.govt_institution_cd
		FROM	IGS_OR_INSTITUTION inst
		WHERE	inst.institution_cd = cp_prior_ug_inst;