DBA Data[Home] [Help]

APPS.IGF_GR_RFMS_ORIG dependencies on IGF_AW_AWARD

Line 717: cp_award_id igf_aw_award_all.award_id%TYPE

713:
714: --Added for bug 3490915
715: -- Get sum of pell award amount
716: CURSOR c_awd_disb_tot(
717: cp_award_id igf_aw_award_all.award_id%TYPE
718: ) IS
719: SELECT DECODE( accepted_amt,0,offered_amt,NULL,offered_amt,accepted_amt) pell_award
720: FROM igf_aw_award awd
721: WHERE awd.award_id = cp_award_id

Line 720: FROM igf_aw_award awd

716: CURSOR c_awd_disb_tot(
717: cp_award_id igf_aw_award_all.award_id%TYPE
718: ) IS
719: SELECT DECODE( accepted_amt,0,offered_amt,NULL,offered_amt,accepted_amt) pell_award
720: FROM igf_aw_award awd
721: WHERE awd.award_id = cp_award_id
722: AND awd.award_status IN ('OFFERED','ACCEPTED');
723: l_awd_disb_tot c_awd_disb_tot%ROWTYPE;
724: