APPS.IGS_AD_GEN_007 SQL Statements

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

Line: 18

		SELECT 	person_id,
			first_name given_names
		FROM 	igs_pe_person_base_v
		WHERE 	last_name     = p_surname AND
			birth_date    = TO_DATE(p_birth_dt, 'DDMMYYYY') AND
			gender        = p_sex;

Line: 86

		SELECT	ci1.cal_type ||
			TO_CHAR(ci1.start_dt, 'DDMMYYYY') ||
			ci2.cal_type ||
			TO_CHAR(ci2.start_dt, 'DDMMYYYY')
		FROM	IGS_AD_APPL			aa,
			IGS_AD_PS_APPL_INST		acai,
			IGS_CA_INST			ci1,
			IGS_CA_INST			ci2
		WHERE	aa.person_id			= p_person_id AND
			aa.admission_appl_number		= p_admission_appl_number AND
			acai.person_id			= aa.person_id AND
			acai.admission_appl_number	= aa.admission_appl_number AND
			acai.nominated_course_cd		= p_nominated_course_cd AND
			acai.sequence_number 		= p_sequence_number AND
			ci1.cal_type			= aa.acad_cal_type AND
			ci1.sequence_number		= (
								SELECT 	sup_ci_sequence_number
								FROM 	IGS_CA_INST_REL
								WHERE	sup_cal_type		= aa.acad_cal_type AND
									sub_cal_type		= acai.adm_cal_type AND
									sub_ci_sequence_number	= acai.adm_ci_sequence_number) AND
			ci2.cal_type  			= acai.adm_cal_type AND
			ci2.sequence_number		= acai.adm_ci_sequence_number;

Line: 168

                SELECT  person_id
                FROM    igs_pe_athletic_dtl
                WHERE   person_id       = p_person_id;

Line: 173

		SELECT	pe_person_id
		FROM	IGS_PE_ALT_PERS_ID
		WHERE	pe_person_id	= p_person_id	;

Line: 178

		SELECT	person_id
		FROM	IGS_PE_PERSON_ADDR	pa,
			IGS_CO_ADDR_TYPE	adt
		WHERE	pa.person_id	= p_person_id	AND
			adt.addr_type	= pa.addr_type	AND
			pa.correspondence_ind	= 'Y';

Line: 185

		SELECT	person_id
		FROM	IGS_PE_PERS_DISABLTY
		WHERE	person_id	= p_person_id;

Line: 189

		SELECT	person_id
		FROM	IGS_PE_VISA
		WHERE	person_id	= p_person_id;

Line: 193

		SELECT	person_id
		FROM	IGS_PE_PERS_NOTE
		WHERE	person_id	= p_person_id;

Line: 197

		SELECT coun.person_id
                FROM IGS_PE_EIT coun,
                     HZ_CITIZENSHIP cz,
		     HZ_PERSON_LANGUAGE lang,
		     IGS_PE_EIT state,
		     IGS_PE_VOTE_INFO_ALL voter,
                     IGS_PE_INCOME_TAX_ALL itax
                WHERE coun.INFORMATION_TYPE = 'PE_STAT_RES_COUNTRY'
                AND coun.person_id = p_person_id
		AND cz.PARTY_ID = coun.person_id
                AND cz.STATUS = 'A'
                AND lang.PARTY_ID = coun.person_id
                AND lang.STATUS = 'A'
                AND state.INFORMATION_TYPE = 'PE_STAT_RES_STATE'
                AND state.person_id = coun.person_id
                AND voter.person_id = coun.person_id
                AND itax.person_id = coun.person_id;

Line: 216

		SELECT	person_id
		FROM	IGS_PE_PERSON_ALIAS
		WHERE	person_id	= p_person_id	;

Line: 220

		SELECT	person_id
		FROM	IGS_AD_TER_EDU
		WHERE	person_id	= p_person_id;

Line: 224

		SELECT	person_id
		FROM	IGS_AD_AUS_SEC_EDU
		WHERE	person_id	= p_person_id;

Line: 228

		SELECT	person_id
		FROM	IGS_AD_OS_SEC_EDU
		WHERE	person_id	= p_person_id;

Line: 232

		SELECT	person_id
		FROM	IGS_AD_EMP_DTL
		WHERE	person_id 	= p_person_id;

Line: 237

		SELECT PI.PARTY_ID
		FROM HZ_PERSON_INTEREST PI, IGS_AD_HZ_EXTRACURR_ACT HEA
		WHERE PI.PERSON_INTEREST_ID = HEA.PERSON_INTEREST_ID
			AND PI.PARTY_ID = p_person_id;

Line: 415

    SELECT  offer_response_offset
    FROM  IGS_AD_PRCS_CAT
    WHERE    admission_cat        = p_admission_cat  AND
      s_admission_process_type  = p_admission_process_type;

Line: 421

    SELECT  adm_appl_offer_resp_dt_alias ,
      adm_appl_due_dt_alias,
      adm_appl_final_dt_alias
    FROM  IGS_AD_CAL_CONF
    WHERE  s_control_num = 1;

Line: 429

    SELECT  apcood.s_admission_process_type,
      apcood.course_cd,
      apcood.version_number,
      apcood.acad_cal_type,
      apcood.location_cd,
      apcood.attendance_mode,
      apcood.attendance_type,
      apcood.dai_sequence_number
    FROM  IGS_AD_PECRS_OFOP_DT  apcood
    WHERE  apcood.adm_cal_type    = p_adm_cal_type    AND
      apcood.adm_ci_sequence_number   = p_adm_ci_sequence_number  AND
      apcood.admission_cat     = p_admission_cat    AND
      apcood.dt_alias     = cp_appl_offer_resp_dt_alias;

Line: 444

    SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
    FROM   IGS_CA_DA_INST  daiv,
       IGS_AD_PERD_AD_CAT  apac
    WHERE  daiv.dt_alias      = v_appl_offer_resp_dt_alias      AND
      apac.adm_cal_type    = p_adm_cal_type    AND
      apac.adm_ci_sequence_number  = p_adm_ci_sequence_number  AND
      apac.admission_cat    = p_admission_cat    AND
      apac.adm_cal_type    = daiv.cal_type      AND
      apac.adm_ci_sequence_number  = daiv.ci_sequence_number  AND
      NOT EXISTS(
        SELECT 'x'
        FROM  IGS_AD_PECRS_OFOP_DT  apcood
        WHERE  apcood.adm_cal_type    = apac.adm_cal_type    AND
          apcood.adm_ci_sequence_number  = apac.adm_ci_sequence_number  AND
          apcood.dt_alias      = daiv.dt_alias      AND
          apcood.dai_sequence_number  = daiv.sequence_number)
    ORDER BY 1 desc;

Line: 463

    SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
    FROM    IGS_CA_DA_INST  daiv
    WHERE  daiv.cal_type      = p_adm_cal_type    AND
      daiv.ci_sequence_number    = p_adm_ci_sequence_number  AND
      daiv.dt_alias      = v_appl_offer_resp_dt_alias      AND
      daiv.sequence_number    = v_dai_sequence_number;

Line: 620

		SELECT	s_adm_appl_status
		FROM	IGS_AD_APPL_STAT
		WHERE	adm_appl_status	= p_adm_appl_status;

Line: 647

		SELECT	s_adm_cndtnl_offer_status
		FROM	IGS_AD_CNDNL_OFRSTAT
		WHERE	adm_cndtnl_offer_status = p_adm_cndtnl_offer_status;

Line: 669

		SELECT	s_adm_doc_status
		FROM	IGS_AD_DOC_STAT
		WHERE	adm_doc_status = p_adm_doc_status;

Line: 690

		SELECT	s_adm_entry_qual_status
		FROM	IGS_AD_ENT_QF_STAT
		WHERE	adm_entry_qual_status = p_adm_entry_qual_status;