[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT lkup.meaning
FROM IGF_LOOKUPS_VIEW lkup
WHERE lkup.lookup_type = cp_lookup_type
AND lkup.lookup_code = cp_lookup_code
AND lkup.enabled_flag = 'Y';
SELECT lkup.meaning
FROM IGS_LOOKUPS_VIEW lkup
WHERE lkup.lookup_type = cp_lookup_type
AND lkup.lookup_code = cp_lookup_code
AND lkup.enabled_flag = 'Y';
SELECT federal_financial_aid
FROM IGS_PS_VER_V
WHERE course_cd = cp_course_cd
AND version_number = cp_version_number;
SELECT DECODE(ins_match_flag, 'Y', 'Y', 'N') primary_dhs,
DECODE(sec_ins_match_flag, 'Y', 'Y', 'N') sec_dhs
FROM IGF_AP_ISIR_MATCHED
WHERE base_id = cp_base_id
AND active_isir = 'Y';
SELECT cty.fin_aid_program_type
FROM IGS_PS_TYPE_ALL cty,
IGS_PS_VER crv
WHERE crv.course_type = cty.course_type
AND crv.course_cd = cp_course_cd
AND crv.version_number = cp_version_number;
SELECT ptype.fin_aid_program_type
FROM IGS_AD_ACAD_HISTORY_V acadhist,
IGS_PS_DEGREES degree,
IGS_PS_TYPE_ALL ptype
WHERE acadhist.degree_earned = degree.degree_cd
AND degree.program_type = ptype.course_type
AND acadhist.person_id = cp_person_id
AND ptype.fin_aid_program_type = cp_fa_program_type;
SELECT course_cd
FROM IGS_EN_STDNT_PS_ATT_ALL
WHERE course_attempt_status = 'COMPLETED'
AND person_id = cp_person_id;
SELECT cty.fin_aid_program_type
FROM IGS_EN_STDNT_PS_ATT_ALL statt,
IGS_PS_TYPE_ALL cty,
IGS_PS_VER crv
WHERE crv.course_cd = statt.course_cd
AND crv.version_number = statt.version_number
AND crv.course_type = cty.course_type
AND statt.course_attempt_status = 'COMPLETED'
AND statt.person_id = cp_person_id
AND cty.fin_aid_program_type = cp_fa_program_type;
SELECT person_id
FROM IGF_AP_FA_CON_V
WHERE base_id = cp_base_id;
SELECT person_id
FROM IGF_AP_FA_CON_V
WHERE base_id = cp_base_id;
CURSOR cur_sequence IS SELECT IGF_GR_PELL_GEN_XML_S.NEXTVAL FROM DUAL;
SELECT rep.ROWID row_id
FROM IGF_AW_FISAP_REP rep
WHERE rep.batch_id = cp_batch_id;
SELECT batch.ROWID row_id, batch.batch_id
FROM IGF_AW_FISAP_BATCH batch
WHERE batch.ci_cal_type = cp_cal_type
AND batch.ci_sequence_number = cp_seq_number;
SELECT fabase.base_id
FROM igf_ap_fa_base_rec fabase
WHERE fabase.ci_cal_type = cp_cal_type
AND fabase.ci_sequence_number = cp_seq_number;
SELECT isir.dependency_status,
isir.isir_id,
DECODE(isir.auto_zero_efc, 'Y', 'Y', 'N') auto_zero_efc,
isir.total_income,
isir.student_total_income
FROM IGF_AP_ISIR_MATCHED isir
WHERE isir.base_id = cp_base_id
AND isir.active_isir = 'Y';
SELECT 'X'
FROM IGF_AP_FA_BASE_REC_ALL fabase,
IGF_AW_AWARD_ALL awd,
IGF_AW_FUND_MAST_ALL fmast,
IGF_AW_FUND_CAT_ALL fcat,
IGS_CA_INST_ALL ca
WHERE ca.cal_type = fabase.ci_cal_type
AND ca.sequence_number = fabase.ci_sequence_number
AND fabase.base_id = awd.base_id
AND fmast.fund_id = awd.fund_id
AND fcat.fund_code = fmast.fund_code
AND ca.cal_type = cp_cal_type
AND ca.sequence_number = cp_seq_number
AND fabase.base_id = cp_base_id
AND ( fcat.fed_fund_code in ('FSEOG', 'PRK')
OR ( fcat.fed_fund_code = 'FWS' AND fcat.fund_source = 'FEDERAL')
);
SELECT SUM(NVL(pay.paid_amount, 0)) paid_amount
FROM IGF_SE_PAYMENT pay,
IGF_SE_AUTH auth,
IGF_AW_AWARD_ALL awd,
IGF_AW_FUND_MAST_ALL fmast,
IGF_AW_FUND_CAT_ALL fcat,
IGF_AP_FA_BASE_REC_ALL fa
WHERE fcat.fund_code=fmast.fund_code
AND fcat.fed_fund_code='FWS'
AND fcat.fund_source='FEDERAL'
AND fmast.fund_id=awd.fund_id
AND awd.base_id=fa.base_id
AND awd.award_id=auth.award_id
AND auth.flag='A'
AND auth.auth_id=pay.auth_id
AND fa.ci_cal_type=fmast.ci_cal_type
AND fa.ci_sequence_number=fmast.ci_sequence_number
AND fa.base_id = cp_base_id
GROUP BY fa.base_id;
SELECT SUM(NVL(disb.disb_paid_amt, 0)) paid_amount
FROM IGF_AP_FA_BASE_REC_ALL fabase,
IGF_AW_AWARD_ALL awd,
IGF_AW_AWD_DISB_ALL disb,
IGF_AW_FUND_MAST_ALL fmast,
IGF_AW_FUND_CAT_ALL fcat
WHERE fabase.base_id = awd.base_id
AND awd.award_id = disb.award_id
AND fmast.fund_id = awd.fund_id
AND fcat.fund_code = fmast.fund_code
AND fcat.fed_fund_code = 'PRK'
AND fabase.base_id = cp_base_id
AND disb.trans_type = 'A'
GROUP BY fabase.base_id;
SELECT SUM(NVL(disb.disb_paid_amt, 0)) paid_amount
FROM IGF_AP_FA_BASE_REC_ALL fabase,
IGF_AW_AWARD_ALL awd,
IGF_AW_AWD_DISB_ALL disb,
IGF_AW_FUND_MAST_ALL fmast,
IGF_AW_FUND_CAT_ALL fcat
WHERE fabase.base_id = awd.base_id
AND awd.award_id = disb.award_id
AND fmast.fund_id = awd.fund_id
AND fcat.fund_code = fmast.fund_code
AND fcat.fed_fund_code = 'FSEOG'
AND fabase.base_id = cp_base_id
AND disb.trans_type = 'A'
GROUP BY fabase.base_id;
igf_aw_fisap_rep_pkg.delete_row(rec_fisap_rep.row_id);
igf_aw_fisap_batch_pkg.delete_row(rec_fisap_batch.row_id);
igf_aw_fisap_batch_pkg.insert_row (
x_rowid => lv_batch_rowid,
x_batch_id => ln_batch_id,
x_ci_cal_type => lv_cal_type,
x_ci_sequence_number => ln_seq_number,
x_description => p_descrption,
x_reported_time_txt => lv_reported_time_txt,
x_mode => 'R'
);
igf_aw_fisap_rep_pkg.insert_row (
x_rowid => lv_rep_rowid,
x_fisap_dtls_id => ln_fisap_dtls_id,
x_batch_id => ln_batch_id,
x_isir_id => ln_isir_id,
x_dependency_status => lv_dependency_status,
x_career_level => lv_career_level,
x_auto_zero_efc_flag => lv_auto_zero_efc,
x_fisap_income_amt => ln_fisap_income,
x_enrollment_status => lv_enrollment_status,
x_perkins_disb_amt => ln_perkins_disb_amt,
x_fws_disb_amt => ln_fws_disb_amt,
x_fseog_disb_amt => ln_fseog_disb_amt,
x_part_ii_section_f_flag => lv_part_II_flag,
x_part_vi_section_a_flag => lv_part_VI_flag,
x_mode => 'R'
);
igf_aw_fisap_batch_pkg.insert_row (
x_rowid => lv_batch_rowid,
x_batch_id => ln_batch_id,
x_ci_cal_type => lv_cal_type,
x_ci_sequence_number => ln_seq_number,
x_description => p_descrption,
x_reported_time_txt => lv_reported_time_txt,
x_mode => 'R'
);
SELECT fs.start_range_amt,
fs.end_range_amt,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with
FROM IGF_AW_FISAP_REP fisap,
IGF_AW_FISAP_RANGES fs,
IGF_AP_BATCH_AW_MAP_ALL awmap
WHERE awmap.ci_cal_type = cp_cal_type
AND awmap.ci_sequence_number = cp_seq_number
AND fs.sys_awd_yr = awmap.sys_award_year
AND fs.part_section = '2F'
AND fs.dependency_status = 'D'
AND fisap.batch_id(+) = cp_batch_id
AND fisap.fisap_income_amt(+) >= fs.start_range_amt
AND fisap.fisap_income_amt(+) <= NVL(fs.end_range_amt, fisap.fisap_income_amt(+))
AND fisap.dependency_status(+) = 'D'
AND fisap.auto_zero_efc_flag(+) = 'N'
AND fisap.part_ii_section_f_flag(+) = 'Y'
GROUP BY fs.start_range_amt, fs.end_range_amt
ORDER BY fs.start_range_amt;
SELECT fs.start_range_amt,
fs.end_range_amt,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'GRAD_PROF', 1, 0)) AS grad_prof
FROM IGF_AW_FISAP_REP fisap,
IGF_AW_FISAP_RANGES fs,
IGF_AP_BATCH_AW_MAP_ALL awmap
WHERE awmap.ci_cal_type = cp_cal_type
AND awmap.ci_sequence_number = cp_seq_number
AND fs.sys_awd_yr = awmap.sys_award_year
AND fs.part_section = '2F'
AND fs.dependency_status = 'I'
AND fisap.batch_id(+) = cp_batch_id
AND fisap.fisap_income_amt(+) >= fs.start_range_amt
AND fisap.fisap_income_amt(+) <= NVL(fs.end_range_amt, fisap.fisap_income_amt(+))
AND fisap.dependency_status(+) = 'I'
AND fisap.auto_zero_efc_flag(+) = 'N'
AND fisap.part_ii_section_f_flag(+) = 'Y'
GROUP BY fs.start_range_amt, fs.end_range_amt
ORDER BY fs.start_range_amt;
SELECT SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with
FROM IGF_AW_FISAP_REP fisap
WHERE fisap.batch_id = cp_batch_id
AND fisap.dependency_status = 'D'
AND fisap.auto_zero_efc_flag = 'Y'
AND fisap.part_ii_section_f_flag = 'Y'
GROUP BY fisap.batch_id;
SELECT SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WOUT', 1, 0)) AS ug_wout,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'UG_WITH', 1, 0)) AS ug_with,
SUM(DECODE(NVL(fisap.career_level, 'ZERO'), 'GRAD_PROF', 1, 0)) AS grad_prof
FROM IGF_AW_FISAP_REP fisap
WHERE fisap.batch_id = cp_batch_id
AND fisap.dependency_status = 'I'
AND fisap.auto_zero_efc_flag = 'Y'
AND fisap.part_ii_section_f_flag = 'Y'
GROUP by fisap.batch_id;
SELECT fs.start_range_amt,
fs.end_range_amt,
SUM(DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1)) AS a,
SUM(NVL(fisap.perkins_disb_amt, 0)) AS b,
SUM(DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1)) AS c,
SUM(NVL(fisap.fseog_disb_amt, 0)) AS d,
SUM(DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1)) AS e,
SUM(NVL(fisap.fws_disb_amt, 0)) AS f,
SUM(DECODE( DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
0, 0, 1
)
) g
FROM IGF_AW_FISAP_REP FISAP,
IGF_AW_FISAP_RANGES FS,
IGF_AP_BATCH_AW_MAP_ALL AWMAP
WHERE awmap.ci_cal_type = cp_cal_type
AND awmap.ci_sequence_number = cp_seq_number
AND fs.sys_awd_yr = awmap.sys_award_year
AND fs.part_section = '6A'
AND fs.dependency_status = 'D'
AND fisap.batch_id(+) = cp_batch_id
AND fisap.fisap_income_amt(+) >= fs.start_range_amt
AND fisap.fisap_income_amt(+) <= NVL(fs.end_range_amt, fisap.fisap_income_amt(+))
AND fisap.dependency_status(+) = 'D'
AND fisap.career_level(+) <> 'GRAD_PROF'
AND fisap.part_vi_section_a_flag(+) = 'Y'
GROUP BY fs.start_range_amt,
fs.end_range_amt
ORDER BY fs.start_range_amt;
SELECT fs.start_range_amt,
fs.end_range_amt,
SUM(DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1)) AS a,
SUM(NVL(fisap.perkins_disb_amt, 0)) AS b,
SUM(DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1)) AS c,
SUM(NVL(fisap.fseog_disb_amt, 0)) AS d,
SUM(DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1)) AS e,
SUM(NVL(fisap.fws_disb_amt, 0)) AS f,
SUM(DECODE( DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
0, 0, 1
)
) g
FROM IGF_AW_FISAP_REP fisap,
IGF_AW_FISAP_RANGES fs,
IGF_AP_BATCH_AW_MAP_ALL awmap
WHERE awmap.ci_cal_type = cp_cal_type
AND awmap.ci_sequence_number = cp_seq_number
AND fs.sys_awd_yr = awmap.sys_award_year
AND fs.part_section = '6A'
AND fs.dependency_status = 'I'
AND fisap.batch_id(+) = cp_batch_id
AND fisap.fisap_income_amt(+) >= fs.start_range_amt
AND fisap.fisap_income_amt(+) <= NVL(fs.end_range_amt, fisap.fisap_income_amt(+))
AND fisap.dependency_status(+) = 'I'
AND fisap.career_level(+) <> 'GRAD_PROF'
AND fisap.part_vi_section_a_flag(+) = 'Y'
GROUP BY fs.start_range_amt,
fs.end_range_amt
ORDER BY fs.start_range_amt;
SELECT SUM(DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1)) AS a,
SUM(NVL(fisap.perkins_disb_amt, 0)) AS b,
SUM(DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1)) AS e,
SUM(NVL(fisap.fws_disb_amt, 0)) AS f,
SUM(DECODE( DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
0, 0, 1
)
) g
FROM IGF_AW_FISAP_REP FISAP
WHERE fisap.batch_id = cp_batch_id
AND fisap.dependency_status = 'I'
AND fisap.career_level = 'GRAD_PROF'
AND fisap.part_vi_section_a_flag = 'Y';
SELECT SUM(DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1)) AS a,
SUM(NVL(fisap.perkins_disb_amt, 0)) AS b,
SUM(DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1)) AS c,
SUM(NVL(fisap.fseog_disb_amt, 0)) AS d,
SUM(DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1)) AS e,
SUM(NVL(fisap.fws_disb_amt, 0)) AS f,
SUM(DECODE( DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
0, 0, 1
)
) g
FROM IGF_AW_FISAP_REP fisap
WHERE fisap.batch_id = cp_batch_id
AND fisap.enrollment_status = 'FT'
AND fisap.part_vi_section_a_flag = 'Y';
SELECT SUM(DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1)) AS a,
SUM(NVL(fisap.perkins_disb_amt, 0)) AS b,
SUM(DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1)) AS c,
SUM(NVL(fisap.fseog_disb_amt, 0)) AS d,
SUM(DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1)) AS e,
SUM(NVL(fisap.fws_disb_amt, 0)) AS f,
SUM(DECODE( DECODE(NVL(fisap.perkins_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fseog_disb_amt, -1), -1, 0, 1) +
DECODE(NVL(fisap.fws_disb_amt, -1), -1, 0, 1) ,
0, 0, 1
)
) g
FROM IGF_AW_FISAP_REP fisap
WHERE fisap.batch_id = cp_batch_id
AND fisap.auto_zero_efc_flag = 'Y'
AND fisap.part_vi_section_a_flag = 'Y';