[Home] [Help]
359: WHERE award_id = cp_award_id;
360:
361: -- Cursor to get the RFMS Disbursement records for the RFMS Records
362: CURSOR c_rfms_disb(
363: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE
364: ) IS
365: SELECT row_id,
366: disb_ack_act_status
367: FROM igf_gr_rfms_disb rfmd
474: l_disb_rec c_disb%ROWTYPE;
475: l_last_disb_num NUMBER;
476:
477: CURSOR c_rfmb_disb(
478: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
480: ) IS
481: SELECT rfmd.rowid row_id,
482: rfmd.*
486: rfmd.disb_ref_num = cp_disb_num ;
487:
488:
489: CURSOR c_rfmd_extra(
490: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
492: ) IS
493: SELECT rfmd.rowid row_id,
494: rfmd.*