APPS.IGS_AD_GEN_003 SQL Statements

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

Line: 30

        SELECT  acai.decision_date,
            acai.decision_make_id
        FROM    IGS_AD_PS_APPL_INST acai
        WHERE   acai.person_id          = p_person_id AND
            acai.admission_appl_number  = p_admission_appl_number AND
            acai.nominated_course_cd    = p_nominated_course_cd AND
            acai.sequence_number        = p_acai_sequence_number AND
            acai.adm_outcome_status IS NOT NULL
        ORDER BY decision_date DESC;

Line: 75

        SELECT  acai.course_cd,
            acai.crv_version_number
        FROM    IGS_AD_PS_APPL_INST acai
        WHERE   acai.person_id         = p_person_id AND
            acai.admission_appl_number = p_admission_appl_number AND
            acai.nominated_course_cd   = p_nominated_course_cd AND
            acai.sequence_number       = p_sequence_number;

Line: 118

        SELECT  acai.adm_outcome_status,
            acai.adm_offer_resp_status,
            aors.s_adm_offer_resp_status
        FROM    IGS_AD_PS_APPL_INST     acai,
            IGS_AD_OFR_RESP_STAT        aors
        WHERE   aors.adm_offer_resp_status  = acai.adm_offer_resp_status AND
            acai.person_id          = p_person_id AND
            acai.admission_appl_number  = p_admission_appl_number AND
            acai.nominated_course_cd    = p_nominated_course_cd AND
            acai.sequence_number        = p_sequence_number;

Line: 171

        SELECT  admission_cd,
            basis_for_admission_type
        FROM    IGS_AD_CD
        WHERE   tac_admission_cd  = p_tac_admission_cd AND
            closed_ind   = 'N'
        ORDER BY basis_for_admission_type ASC;

Line: 228

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

Line: 233

        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           = p_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: 251

        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           = p_dt_alias            AND
            daiv.sequence_number        = v_dai_sequence_number;

Line: 258

        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         = p_dt_alias;

Line: 496

        SELECT  apcs.s_admission_step_type
        FROM    IGS_AD_PRCS_CAT_STEP    apcs
        WHERE   admission_cat           = p_admission_cat       AND
            s_admission_process_type    = p_s_admission_process_type    AND
            mandatory_step_ind      = 'Y' AND
            step_group_type <> 'TRACK'; -- 2402377

Line: 769

        SELECT  apcs.s_admission_step_type
        FROM    IGS_AD_PRCS_CAT_STEP apcs
        WHERE   apcs.admission_cat = cp_admission_cat AND
                apcs.s_admission_process_type = cp_s_admission_process_type AND
                apcs.s_admission_step_type = cp_s_admission_step_type AND
        apcs.step_group_type = 'OUTCOME';

Line: 816

    SELECT   apcs.s_admission_step_type
    FROM     igs_ad_prcs_cat_step_all apcs, igs_ad_appl_all appl
    WHERE    appl.person_id = p_person_id
    AND      appl.admission_appl_number = p_admission_appl_number
    AND      apcs.admission_cat = appl.admission_cat
    AND      apcs.s_admission_process_type = appl.s_admission_process_type
    AND      apcs.step_group_type = 'UNIT-VAL'
    AND      apcs.s_admission_step_type IN ('CORE','CORE_OPTIONAL')
    ORDER BY apcs.s_admission_step_type desc;

Line: 890

        SELECT  'X'
        FROM    IGS_AD_PRCS_CAT_STEP
        WHERE   admission_cat = p_admission_cat AND
                s_admission_process_type = p_s_admission_process_type AND
                s_admission_step_type = 'LATE-APP' AND
                step_group_type <> 'TRACK';

Line: 898

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