APPS.IGS_RE_VAL_CA SQL Statements

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

Line: 238

                SELECT  sca.course_attempt_status

                FROM    IGS_EN_STDNT_PS_ATT sca

                WHERE   sca.person_id = p_person_id AND

                        sca.course_cd = p_sca_course_cd;

Line: 246

	SELECT 'x'
	FROM igs_en_spa_awd_aim
	WHERE person_id = p_person_id
	AND      course_cd = p_sca_course_cd
	AND ( 	end_dt IS NULL OR
		(end_dt IS NOT NULL AND complete_ind = 'Y')
 	    );

Line: 254

	SELECT 'x'
	FROM igs_en_spa_awd_aim
	WHERE person_id =  p_person_id
	AND course_cd = p_sca_course_cd
	AND NVL(complete_ind,'N') = 'N'
	AND end_dt IS NULL;

Line: 367

                SELECT  sca.student_confirmed_ind
                FROM    IGS_EN_STDNT_PS_ATT             sca
                WHERE   sca.person_id                   = p_person_id AND
                        sca.course_cd                   = p_sca_course_cd;

Line: 372

                SELECT  aos.s_adm_outcome_status
                FROM    IGS_AD_PS_APPL_INST     acai,
                        IGS_AD_OU_STAT          aos
                WHERE   acai.person_id                  = p_person_id AND
                        acai.admission_appl_number      = p_acai_admission_appl_number AND
                        acai.nominated_course_cd        = p_acai_nominated_course_cd AND
                        acai.sequence_number            = p_acai_sequence_number AND
                        acai.adm_outcome_status         = aos.adm_outcome_status;

Line: 536

                SELECT  aa.s_admission_process_type

                FROM    IGS_AD_APPL                     aa

                WHERE   aa.person_id                    = p_person_id AND

                        aa.admission_appl_number        = p_acai_admission_appl_number;

Line: 548

                SELECT  'x'

                FROM    IGS_RE_CANDIDATURE ca

                WHERE   ca.person_id                    = p_person_id AND

                        (p_ca_sequence_number           IS NULL OR

                        ca.sequence_number              <> p_ca_sequence_number) AND

                        ca.acai_admission_appl_number   = p_acai_admission_appl_number AND

                        ca.acai_nominated_course_cd     = p_acai_nominated_course_cd AND

                        ca.acai_sequence_number         = p_acai_sequence_number;

Line: 568

                SELECT  'x'

                FROM    IGS_AD_APPL aa,

                        IGS_AD_PRCS_CAT_STEP apcs

                WHERE   aa.person_id                    = p_person_id AND

                        aa.admission_appl_number        = p_acai_admission_appl_number AND

                        aa.admission_cat                = apcs.admission_cat AND

                        aa.s_admission_process_type     = apcs.s_admission_process_type AND

                        apcs.s_admission_step_type      = cst_research AND

                        apcs.step_group_type            <> 'TRACK'; --2402377

Line: 781

                SELECT  sca.student_confirmed_ind
                FROM    IGS_EN_STDNT_PS_ATT sca
                WHERE   sca.person_id = p_person_id     AND
                        sca.course_cd = p_sca_course_cd;

Line: 786

                SELECT  aos.s_adm_outcome_status
                FROM    IGS_AD_PS_APPL_INST     acai,
                        IGS_AD_OU_STAT          aos
                WHERE   acai.person_id                  = p_person_id                   AND
                        acai.admission_appl_number      = p_acai_admission_appl_number  AND
                        acai.nominated_course_cd        = p_acai_nominated_course_cd    AND
                        acai.sequence_number            = p_acai_sequence_number        AND
                        acai.adm_outcome_status         = aos.adm_outcome_status;

Line: 935

                SELECT  sca.student_confirmed_ind
                FROM    IGS_EN_STDNT_PS_ATT sca
                WHERE   sca.person_id = p_person_id     AND
                        sca.course_cd = p_sca_course_cd;

Line: 940

                SELECT  aos.s_adm_outcome_status
                FROM    IGS_AD_PS_APPL_INST     acai,
                        IGS_AD_OU_STAT          aos
                WHERE   acai.person_id                  = p_person_id                   AND
                        acai.admission_appl_number      = p_acai_admission_appl_number  AND
                        acai.nominated_course_cd        = p_acai_nominated_course_cd    AND
                        acai.sequence_number            = p_acai_sequence_number        AND
                        acai.adm_outcome_status         = aos.adm_outcome_status;

Line: 1116

                SELECT  sca.student_confirmed_ind,

                        sca.course_attempt_status

                FROM    IGS_EN_STDNT_PS_ATT sca

                WHERE   sca.person_id   = p_person_id AND

                        sca.course_cd   = cp_course_cd;

Line: 1130

                SELECT  'x'

                FROM    IGS_RE_CANDIDATURE ca

                WHERE   ca.person_id    = p_person_id AND

                        (p_ca_sequence_number IS NULL OR

                        ca.sequence_number <> p_ca_sequence_number) AND

                        ca.sca_course_cd= p_sca_course_cd;

Line: 1341

                SELECT  aos.s_adm_outcome_status,

                        cty.research_type_ind

                FROM    IGS_AD_PS_APPL_INST     acai,

                        IGS_AD_OU_STAT          aos,

                        IGS_PS_VER                      crv,

                        IGS_PS_TYPE                     cty

                WHERE   acai.person_id                  = p_person_id AND

                        acai.admission_appl_number      = p_acai_admission_appl_number AND

                        acai.nominated_course_cd        = p_acai_nominated_course_cd AND

                        acai.sequence_number            = p_acai_sequence_number AND

                        acai.course_cd                  = crv.course_cd AND

                        acai.crv_version_number         = crv.version_number AND

                        acai.adm_outcome_status         = aos.adm_outcome_status AND

                        crv.course_type                 = cty.course_type;

Line: 1371

                SELECT  apcs.mandatory_step_ind

                FROM    IGS_AD_APPL                     aa,

                        IGS_AD_PRCS_CAT_STEP            apcs

                WHERE   aa.person_id                    = p_person_id AND

                        aa.admission_appl_number        = p_acai_admission_appl_number AND

                        aa.admission_cat                = apcs.admission_cat AND

                        aa.s_admission_process_type     = apcs.s_admission_process_type AND

                        apcs.s_admission_step_type      = 'RESEARCH' AND

                        apcs.step_group_type            <> 'TRACK'; --2402377

Line: 1522

                SELECT  sca.student_confirmed_ind,

                        cty.research_type_ind

                FROM    IGS_EN_STDNT_PS_ATT sca,

                        IGS_PS_VER crv,

                        IGS_PS_TYPE cty

                WHERE   sca.course_cd           = crv.course_cd AND

                        sca.version_number      = crv.version_number AND

                        crv.course_type         = cty.course_type AND

                        sca.person_id           = p_person_id AND

                        sca.course_cd           = p_sca_course_cd;

Line: 1629

                SELECT  'X'

                FROM    IGS_RE_GV_TOA_CLS_CD

                WHERE   govt_toa_class_cd = p_govt_toa_class_cd AND

                        closed_ind = 'Y';

Line: 1718

                SELECT  sca.adm_admission_appl_number,

                        sca.adm_nominated_course_cd,

                        sca.adm_sequence_number

                FROM    IGS_EN_STDNT_PS_ATT     sca

                WHERE   sca.person_id           = p_person_id AND

                        sca.course_cd           = p_sca_course_cd;