[Home] [Help]
900: (reverse chronological order - newest change first)
901: akomurav 24-1-2006 FA162.The values of Acad begin date and end date are now directly populated fromIGF_SL_LOR_ALL table i.e p_loan_rec record.
902: ***************************************************************/
903:
904: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
905: SELECT db.award_id,
906: db.disb_num,
907: db.disb_seq_num,
908: db.disb_accepted_amt,
909: db.disb_date,
910: db.orig_fee_amt,
911: db.disb_net_amt,
912: db.interest_rebate_amt
913: FROM igf_aw_db_chg_dtls db
914: WHERE db.award_id = cp_award_id;
915:
916: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
1529: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1530: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' LOAN_AMT_ACCEPTED Check Over');
1531: END IF;
1532:
1533: -- validating disbursement data from the IGF_AW_DB_CHG_DTLS table
1534: FOR rec_disb_chg_dtls IN cur_disb_chg_dtls(p_loan_rec.award_id) LOOP
1535: -- validating disbursement gross amount
1536: IF rec_disb_chg_dtls.disb_accepted_amt >= 999999999.99 OR rec_disb_chg_dtls.disb_accepted_amt < 0 THEN
1537: lv_complete := FALSE;