[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
faconv.base_id,
faconv.person_id,
faconv.ci_cal_type,
faconv.ci_sequence_number,
faconv.coa_code_f,
fed_verif_status,
coa_pell,
pell_alt_expense,
isir.transaction_num,
isir.original_ssn,
isir.orig_name_id,
isir.secondary_efc,
isir.sec_efc_type,
isir.isir_id
FROM
igf_ap_fa_base_rec faconv,
igf_ap_isir_matched isir
WHERE
x_base_id = faconv.base_id AND
faconv.base_id = isir.base_id AND
isir.active_isir = 'Y'
ORDER BY 1;
SELECT awd.base_id,
awd.award_id,
awd.offered_amt,
awd.accepted_amt,
awd.fund_id,
awd.alt_pell_schedule,
fmast.ci_cal_type,
fmast.ci_sequence_number
FROM igf_aw_award awd,
igf_aw_fund_mast fmast,
igf_aw_fund_cat fcat
WHERE fmast.ci_cal_type = p_ci_cal_type
AND fmast.ci_sequence_number = p_ci_seq_num
AND awd.base_id = NVL(x_base_id,awd.base_id)
AND fcat.fed_fund_code = 'PELL'
AND awd.award_status IN ('ACCEPTED','OFFERED')
AND awd.fund_id = fmast.fund_id
AND fmast.fund_code = fcat.fund_code
ORDER BY
awd.base_id,
awd.award_id;
SELECT
awd.*
FROM
igf_aw_awd_disb awd
WHERE
awd.award_id = x_award_id
ORDER BY awd.disb_num ;
SELECT
rfms.origination_id
FROM
igf_gr_rfms rfms
WHERE
rfms.award_id = x_award_id ;
SELECT
rfmd.origination_id
FROM
igf_gr_rfms rfms,
igf_gr_rfms_disb rfmd
WHERE
rfms.origination_id = rfmd.origination_id AND
rfmd.disb_ref_num = x_disb_num AND
rfms.award_id = x_award_id ;
SELECT
adisb1.disb_num,
adisb2.disb_date
FROM
igf_aw_awd_disb adisb1,
igf_aw_awd_disb adisb2
WHERE
p_award_id = adisb1.award_id
AND
adisb1.disb_num
IN(SELECT MAX(adisb11.disb_num) FROM igf_aw_awd_disb adisb11
WHERE adisb11.award_id = adisb1.award_id)
AND
adisb1.award_id = adisb2.award_id
AND
adisb2.disb_num
IN( SELECT MIN(adisb11.disb_num) FROM igf_aw_awd_disb adisb11
WHERE adisb11.award_id = adisb2.award_id);
SELECT isir_id
FROM igf_ap_isir_matched
WHERE base_id = c_base_id
AND payment_isir = 'Y';
SELECT 'Y'
FROM igf_gr_rfms
WHERE origination_id = c_orig_id;
SELECT coa_pell
FROM igf_ap_fa_base_rec_all
WHERE base_id = cp_base_id;
SELECT rep.reporting_pell_cd
FROM
igf_gr_attend_pell gap,
igf_gr_report_pell rep
WHERE
gap.ci_cal_type = cp_cal_type AND
gap.ci_sequence_number = cp_seq_num AND
gap.attending_pell_cd = cp_att_pell_id AND
gap.rcampus_id = rep.rcampus_id;
SELECT rep.rep_entity_id_txt
FROM igf_gr_attend_pell att,
igf_gr_report_pell rep
WHERE att.rcampus_id = rep.rcampus_id
AND att.ci_cal_type = cp_cal_type
AND att.ci_sequence_number = cp_seq_num
AND att.atd_entity_id_txt = cp_atd_entity_id;
SELECT base_attendance_type_code
FROM igf_aw_awd_disb_all
WHERE award_id = cp_award_id
GROUP BY base_attendance_type_code;
igf_gr_rfms_pkg.insert_row ( x_rowid => lv_row_id,
x_origination_id => l_rfms_rec.origination_id,
x_ci_cal_type => l_rfms_rec.ci_cal_type,
x_ci_sequence_number => l_rfms_rec.ci_sequence_number,
x_base_id => l_rfms_rec.base_id,
x_award_id => l_rfms_rec.award_id,
x_rfmb_id => l_rfms_rec.rfmb_id,
x_sys_orig_ssn => l_rfms_rec.sys_orig_ssn,
x_sys_orig_name_cd => l_rfms_rec.sys_orig_name_cd,
x_transaction_num => l_rfms_rec.transaction_num,
x_efc => l_rfms_rec.efc,
x_ver_status_code => l_rfms_rec.ver_status_code,
x_secondary_efc => l_rfms_rec.secondary_efc,
x_secondary_efc_cd => l_rfms_rec.secondary_efc_cd,
x_pell_amount => l_rfms_rec.pell_amount,
x_pell_profile => l_rfms_rec.pell_profile,
x_enrollment_status => l_rfms_rec.enrollment_status,
x_enrollment_dt => l_rfms_rec.enrollment_dt,
x_coa_amount => l_rfms_rec.coa_amount,
x_academic_calendar => l_rfms_rec.academic_calendar,
x_payment_method => l_rfms_rec.payment_method,
x_total_pymt_prds => l_rfms_rec.total_pymt_prds,
x_incrcd_fed_pell_rcp_cd => l_rfms_rec.incrcd_fed_pell_rcp_cd,
x_attending_campus_id => l_rfms_rec.attending_campus_id,
x_est_disb_dt1 => l_rfms_rec.est_disb_dt1,
x_orig_action_code => l_rfms_rec.orig_action_code,
x_orig_status_dt => l_rfms_rec.orig_status_dt,
x_orig_ed_use_flags => l_rfms_rec.orig_ed_use_flags,
x_ft_pell_amount => l_rfms_rec.ft_pell_amount,
x_prev_accpt_efc => l_rfms_rec.prev_accpt_efc,
x_prev_accpt_tran_no => l_rfms_rec.prev_accpt_tran_no,
x_prev_accpt_sec_efc_cd => l_rfms_rec.prev_accpt_sec_efc_cd,
x_prev_accpt_coa => l_rfms_rec.prev_accpt_coa,
x_orig_reject_code => l_rfms_rec.orig_reject_code,
x_wk_inst_time_calc_pymt => l_rfms_rec.wk_inst_time_calc_pymt,
x_wk_int_time_prg_def_yr => l_rfms_rec.wk_int_time_prg_def_yr,
x_cr_clk_hrs_prds_sch_yr => l_rfms_rec.cr_clk_hrs_prds_sch_yr,
x_cr_clk_hrs_acad_yr => l_rfms_rec.cr_clk_hrs_acad_yr,
x_inst_cross_ref_cd => l_rfms_rec.inst_cross_ref_cd,
x_low_tution_fee => l_rfms_rec.low_tution_fee,
x_rec_source => l_rfms_rec.rec_source,
x_pending_amount => l_rfms_rec.pending_amount,
x_mode => 'R',
x_birth_dt => NULL,
x_last_name => NULL,
x_first_name => NULL,
x_middle_name => NULL,
x_current_ssn => NULL,
x_legacy_record_flag => NULL,
x_reporting_pell_cd => l_rep_pell_id,
x_rep_entity_id_txt => l_rep_entity_id,
x_atd_entity_id_txt => l_attend_entity_id,
x_note_message => NULL,
x_full_resp_code => l_rfms_rec.full_resp_code,
x_document_id_txt => NULL );
igf_gr_rfms_disb_pkg.insert_row (x_mode => 'R',
x_rowid => lv_row_id,
x_rfmd_id => lv_rfmd_id,
x_origination_id => l_rfmsd_rec.origination_id,
x_disb_ref_num => l_rfmsd_rec.disb_ref_num,
x_disb_dt => l_rfmsd_rec.disb_dt,
x_disb_amt => l_rfmsd_rec.disb_amt,
x_db_cr_flag => l_rfmsd_rec.db_cr_flag,
x_disb_ack_act_status => l_rfmsd_rec.disb_ack_act_status ,
x_disb_status_dt => l_rfmsd_rec.disb_status_dt ,
x_accpt_disb_dt => l_rfmsd_rec.accpt_disb_dt ,
x_disb_accpt_amt => l_rfmsd_rec.disb_accpt_amt ,
x_accpt_db_cr_flag => l_rfmsd_rec.accpt_db_cr_flag ,
x_disb_ytd_amt => l_rfmsd_rec.disb_ytd_amt ,
x_pymt_prd_start_dt => l_rfmsd_rec.pymt_prd_start_dt ,
x_accpt_pymt_prd_start_dt => l_rfmsd_rec.accpt_pymt_prd_start_dt ,
x_edit_code => l_rfmsd_rec.edit_code ,
x_rfmb_id => l_rfmsd_rec.rfmb_id,
x_ed_use_flags => l_rfmsd_rec.ed_use_flags);
END IF; -- phase-in, insert gr disbursement
SELECT
isir.original_ssn,
isir.orig_name_id
FROM
igf_ap_isir_matched isir
WHERE isir.base_id = x_base_id
AND isir.active_isir = 'Y' ;
SELECT
ci_cal_type,ci_sequence_number
FROM
igf_ap_fa_base_rec fabase
WHERE
fabase.base_id = x_base_id;
SELECT ld_cal_type,ld_sequence_number
FROM igf_aw_awd_disb_all
WHERE award_id = cp_award_id
AND trans_type <> 'C';
SELECT base_id
FROM igf_aw_award_all
WHERE award_id = cp_award_id;