[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM igf_ap_fa_base_rec_all
WHERE base_id = l_base_id;
SELECT dependency_status
FROM igf_ap_isir_matched_all
WHERE base_id = l_base_id AND
payment_isir = 'Y' AND
system_record_type = 'ORIGINAL';
SELECT subs_annual_lt, tot_annual_lt, subs_aggr_lt, tot_aggr_lt
FROM igf_aw_loan_limit_all
WHERE ci_cal_type = x_ci_cal_type AND
ci_sequence_number = x_ci_sequence_number AND
depend_stat = x_depend_stat AND
ffelp_grade_level = x_fl_grad_lvl;
SELECT subs_annual_lt, tot_annual_lt, subs_aggr_lt, tot_aggr_lt
FROM igf_aw_loan_limit_all
WHERE ci_cal_type = x_ci_cal_type AND
ci_sequence_number = x_ci_sequence_number AND
depend_stat = x_depend_stat AND
dl_grade_level = x_dl_grad_lvl;
CURSOR c_nslds_loans IS SELECT
NVL(nslds.nslds_agg_subsz_out_prin_bal,0) aggr_subs_loan,
NVL(nslds.nslds_agg_comb_out_prin_bal,0) aggr_total_loan,
isir.tran_process_date
FROM igf_ap_isir_matched_all isir,igf_ap_nslds_data nslds
WHERE nslds.base_id = l_base_id
AND isir.isir_id = nslds.isir_id
ORDER BY TO_NUMBER(nslds.transaction_num_txt) DESC;
SELECT SUM (NVL (awd.offered_amt, 0)) loan_amt,
SUM (DECODE (
fcat.fed_fund_code,
'FLS', NVL (awd.offered_amt, 0),
'DLS', NVL (awd.offered_amt, 0),
0
)) subs_loan_amt
FROM igf_aw_award_all awd,
igf_aw_fund_mast fm,
igf_aw_fund_cat_all fcat,
igf_ap_fa_base_rec_all fa
WHERE fa.person_id IN (SELECT person_id
FROM igf_ap_fa_base_rec_all
WHERE base_id = l_base_id)
AND awd.base_id = fa.base_id
AND awd.fund_id = fm.fund_id
AND ( cp_awd_date IS NULL
OR TRUNC (awd.award_date) >= TRUNC (cp_awd_date))
AND awd.award_status IN ('OFFERED', 'ACCEPTED')
AND fcat.fund_code = fm.fund_code
AND fcat.fed_fund_code IN ('DLS', 'DLU', 'FLS', 'FLU');
SELECT SUM(NVL(awd.offered_amt,0)) loan_amt,
SUM(DECODE(fcat.fed_fund_code,'FLS',
NVL(awd.offered_amt,0),'DLS',NVL(awd.offered_amt,0),0)) subs_loan_amt
FROM igf_aw_award_all awd,
igf_aw_fund_mast_all fm,
igf_aw_fund_cat_all fcat
WHERE awd.base_id = l_base_id
AND awd.fund_id = fm.fund_id
AND awd.award_status IN ('OFFERED','ACCEPTED')
AND fcat.fund_code = fm.fund_code
AND fcat.fed_fund_code IN ('DLS','DLU','FLS','FLU');
SELECT override_grade_level_code
FROM igf_sl_lor_all lor,
igf_sl_loans_all loan
WHERE loan.loan_id = lor.loan_id
AND loan.award_id = p_award_id;
|| brajendr 03-Dec-2003 FA 128 Isir Update
|| Modified the logic for deriving the PELL EFC
||
|| rasahoo 27-Nov-2003 FA 128 Isir Update
|| Changed the query string 'qry_str'
||
|| cdcruz 05-feb-03 Bug# 2758804 FACR105
|| cursor c_isir_id ref changed to pick active isisr
*/
CURSOR c_isir_id ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
SELECT isir_id,
primary_efc,
NVL(auto_zero_efc,'N') auto_zero_efc
FROM igf_ap_isir_matched
WHERE base_id = x_base_id
AND active_isir = 'Y';
SELECT DECODE(fa.award_fmly_contribution_type, 2, isir.secondary_efc, isir.primary_efc) pell_efc
FROM igf_ap_fa_base_rec_all fa,
igf_ap_isir_matched_all isir
WHERE fa.base_id = isir.base_id
AND fa.base_id = cp_base_id
AND isir.active_isir = 'Y';
SELECT award_fmly_contribution_type
FROM igf_ap_fa_base_rec_all
WHERE base_id = cp_base_id;
SELECT DECODE (
cp_awd_fmly_contrib_type,
2, DECODE (
cp_months_num,
1, isir.sec_alternate_month_1,
2, isir.sec_alternate_month_2,
3, isir.sec_alternate_month_3,
4, isir.sec_alternate_month_4,
5, isir.sec_alternate_month_5,
6, isir.sec_alternate_month_6,
7, isir.sec_alternate_month_7,
8, isir.sec_alternate_month_8,
9, isir.secondary_efc,
10, isir.sec_alternate_month_10,
11, isir.sec_alternate_month_11,
12, isir.sec_alternate_month_12
),
DECODE (
cp_months_num,
1, isir.primary_alternate_month_1,
2, isir.primary_alternate_month_2,
3, isir.primary_alternate_month_3,
4, isir.primary_alternate_month_4,
5, isir.primary_alternate_month_5,
6, isir.primary_alternate_month_6,
7, isir.primary_alternate_month_7,
8, isir.primary_alternate_month_8,
9, isir.primary_efc,
10, isir.primary_alternate_month_10,
11, isir.primary_alternate_month_11,
12, isir.primary_alternate_month_12
)
) efc
FROM igf_ap_isir_matched isir
WHERE isir.isir_id = cp_isir_id;
CURSOR c_enrl_dtl_cur IS SELECT
ci.cal_type enrl_load_cal_type,
ci.sequence_number enrl_load_seq_num ,
ci.alternate_code enrolled_term ,
TRUNC(ci.start_dt) enrolled_start_dt,
TRUNC(ci.end_dt) enrolled_end_dt
FROM
igs_ca_inst ci,
igs_ca_type cty
WHERE cty.s_cal_cat = 'LOAD'
AND cty.cal_type = ci.cal_type
AND (ci.cal_type, ci.sequence_number)
IN
(
SELECT sup_cal_type,
sup_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sub_cal_type = l_acad_cal_type
AND sub_ci_sequence_number = l_acad_seq_num
UNION
SELECT sub_cal_type,
sub_ci_sequence_number
FROM igs_ca_inst_rel
WHERE sup_cal_type = l_acad_cal_type
AND sup_ci_sequence_number = l_acad_seq_num
)
AND
TRUNC(SYSDATE) BETWEEN TRUNC(ci.start_dt) AND TRUNC(ci.end_dt)
ORDER BY ci.start_dt;
SELECT MIN(terms.start_date) start_dt
FROM igf_aw_dp_terms_v terms
WHERE terms.adplans_id = cp_adplans_id;
SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) start_dt
FROM igf_aw_awd_disb_v disb,
igf_aw_award_all awd
WHERE disb.award_id = cp_award_id
AND disb.award_id = awd.award_id
ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number);
SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
FROM
igf_aw_coa_term_tot_v coa_terms,
igf_aw_dp_terms dp_terms,
igf_aw_awd_dist_plans adplans
WHERE
dp_terms.ld_cal_type = coa_terms.ld_cal_type
AND dp_terms.ld_sequence_number = coa_terms.ld_sequence_number
AND dp_terms.adplans_id = adplans.adplans_id
AND coa_terms.base_id = cp_base_id
AND dp_terms.adplans_id = cp_adplans_id
ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
SELECT igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ear_term_start_date
FROM igf_aw_dp_terms dp_terms,
igf_aw_awd_dist_plans adplans
WHERE dp_terms.adplans_id = adplans.adplans_id
AND dp_terms.adplans_id = cp_adplans_id
ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, dp_terms.ld_cal_type, dp_terms.ld_sequence_number) ASC;
SELECT igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ear_term_start_date
FROM igf_aw_awd_disb_all disb,
igf_aw_award_all awd
WHERE awd.award_id = cp_award_id
AND awd.award_id = disb.award_id
ORDER BY igf_aw_packaging.get_term_start_date(awd.base_id, disb.ld_cal_type, disb.ld_sequence_number) ASC;
SELECT ant_data.class_standing class_standing,
ant_data.ld_cal_type load_cal_type,
ant_data.ld_sequence_number load_seq_num
FROM
igf_aw_awd_prd_term awd_per,
igs_ca_inst_all cal_inst,
igf_ap_fa_ant_data ant_data,
igf_ap_fa_base_rec_all fabase
WHERE
awd_per.ld_cal_type = cal_inst.cal_type AND
awd_per.ld_sequence_number = cal_inst.sequence_number AND
ant_data.ld_cal_type = awd_per.ld_cal_type AND
ant_data.ld_sequence_number = awd_per.ld_sequence_number AND
awd_per.ci_cal_type = fabase.ci_cal_type AND
awd_per.ci_sequence_number = fabase.ci_sequence_number AND
fabase.base_id = cp_base_id AND
awd_per.award_prd_cd = cp_awd_per AND
ant_data.base_id = cp_base_id AND
ant_data.class_standing IS NOT NULL
ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, awd_per.ld_cal_type, awd_per.ld_sequence_number) ASC;
SELECT ant_data.program_type prog_type,
ant_data.ld_cal_type load_cal_type,
ant_data.ld_sequence_number load_seq_num
FROM
igf_aw_awd_prd_term awd_per,
igs_ca_inst_all cal_inst,
igf_ap_fa_ant_data ant_data,
igf_ap_fa_base_rec_all fabase
WHERE
awd_per.ld_cal_type = cal_inst.cal_type AND
awd_per.ld_sequence_number = cal_inst.sequence_number AND
ant_data.ld_cal_type = awd_per.ld_cal_type AND
ant_data.ld_sequence_number = awd_per.ld_sequence_number AND
awd_per.ci_cal_type = fabase.ci_cal_type AND
awd_per.ci_sequence_number = fabase.ci_sequence_number AND
fabase.base_id = cp_base_id AND
awd_per.award_prd_cd = cp_awd_per AND
ant_data.base_id = cp_base_id AND
ant_data.program_type IS NOT NULL
ORDER BY igf_aw_packaging.get_term_start_date(cp_base_id, awd_per.ld_cal_type, awd_per.ld_sequence_number) ASC;
SELECT ci_cal_type, ci_sequence_number
FROM igf_ap_fa_base_rec
WHERE base_id = cp_base_id;