[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT '1'
FROM igf_aw_db_chg_dtls adtlv,
igf_aw_award awd,
igf_sl_loans lar,
igf_ap_fa_base_rec fabase
WHERE -- ## Pick up all records with SF Status 1)"to be Posted" and Pick up Disbursements with Future dates and within 7 Future days,
-- "Posted" to Student Account.
adtlv.disb_date-TRUNC(SYSDATE) <=7
AND adtlv.disb_status = 'G' -- ## With Disbursement Status as Ready to Send
AND adtlv.award_id = awd.award_id
AND adtlv.award_id = lar.award_id
AND awd.base_id = fabase.base_id
AND fabase.ci_cal_type = lv_ci_cal_type
AND fabase.ci_sequence_number = lv_ci_sequence_number
AND substr(lar.loan_number, 13, 6) = p_school_code;
SELECT meaning
FROM igs_lookups_view
WHERE lookup_type = 'OR_SYSTEM_ID_TYPE'
AND lookup_code = 'DL_SCH_CD'
AND enabled_flag = 'Y';
2. Inserts the Batch ID details in igf_sl_dl_batch
3. For the specified version, Opens a REF CURSOR, having
header file Specs.
*************************************************************************/
OPEN cur_disb_dtl(lv_cal_type,lv_cal_seq_num);
SELECT adtlv.*, fabase.base_id, lar.loan_number
FROM igf_aw_db_chg_dtls adtlv,
igf_aw_award awd,
igf_sl_loans lar,
igf_ap_fa_base_rec fabase
WHERE
adtlv.disb_date-TRUNC(SYSDATE) <=7
AND adtlv.disb_status = 'G' -- ## With Disbursement Status as Ready to Send
AND adtlv.award_id = awd.award_id
AND adtlv.award_id = lar.award_id
AND awd.base_id = fabase.base_id
AND fabase.ci_cal_type = p_ci_cal_type
AND fabase.ci_sequence_number = p_ci_sequence_number
AND substr(lar.loan_number, 13, 6) = p_school_code
ORDER BY adtlv.disb_num, adtlv.disb_seq_num;
SELECT orig_fee_perct_stafford, orig_fee_perct_plus FROM igf_sl_dl_setup
WHERE ci_cal_type = p_ci_cal_type
AND ci_sequence_number = p_ci_sequence_number;
SELECT awd.fund_id, fcat.fed_fund_code
FROM igf_aw_fund_mast fmast,
igf_aw_fund_cat fcat,
igf_aw_award awd
WHERE awd.award_id = p_award_id
AND awd.fund_id = fmast.fund_id
AND fmast.fund_code = fcat.fund_code;
SELECT MIN(disb_num)
FROM igf_aw_awd_disb
WHERE award_id = cp_award_id;
SELECT disb_date
FROM igf_aw_db_chg_dtls
WHERE award_id = cp_award_id
AND disb_num = cp_disb_num
AND disb_seq_num = cp_disb_seq_num;
SELECT igf_aw_db_chg_dtls.*,igf_aw_db_chg_dtls.ROWID
FROM igf_aw_db_chg_dtls
WHERE award_id = lcur_disb_dtl.award_Id
AND disb_num = lcur_disb_dtl.disb_num
AND disb_seq_num = lcur_disb_dtl.disb_seq_num
FOR UPDATE OF award_Id NOWAIT;
igf_aw_db_chg_dtls_pkg.update_row (
x_rowid => tbh_rec.ROWID,
x_award_id => tbh_rec.award_id,
x_disb_num => tbh_rec.disb_num,
x_disb_seq_num => tbh_rec.disb_seq_num,
x_disb_accepted_amt => tbh_rec.disb_accepted_amt,
x_orig_fee_amt => tbh_rec.orig_fee_amt,
x_disb_net_amt => tbh_rec.disb_net_amt,
x_disb_date => tbh_rec.disb_date,
x_disb_activity => tbh_rec.disb_activity,
x_disb_status => 'S',
x_disb_status_date => TRUNC(SYSDATE),
x_disb_rel_flag => tbh_rec.disb_rel_flag,
x_first_disb_flag => tbh_rec.first_disb_flag,
x_interest_rebate_amt => tbh_rec.interest_rebate_amt,
x_disb_conf_flag => tbh_rec.disb_conf_flag,
x_pymnt_prd_start_date => tbh_rec.pymnt_prd_start_date,
x_note_message => tbh_rec.note_message,
x_batch_id_txt => p_dl_batch_Id,
x_ack_date => tbh_rec.ack_date,
x_booking_id_txt => tbh_rec.booking_id_txt,
x_booking_date => tbh_rec.booking_date,
x_mode => 'R');