[Home] [Help]
2073: ) IS
2074: SELECT alt_pell_schedule
2075: FROM igf_aw_award_all awd,
2076: igf_aw_fund_mast_all fmast,
2077: igf_aw_fund_cat_all fcat
2078: WHERE awd.base_id = p_base_id
2079: AND awd.fund_id = fmast.fund_id
2080: AND awd.award_status IN ('ACCEPTED','OFFERED')
2081: AND fmast.fund_code = fcat.fund_code
2865:
2866: END update_current_ssn;
2867:
2868: PROCEDURE update_pell_status (p_award_id IN igf_aw_award_all.award_id%TYPE,
2869: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
2870: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
2871: p_status_desc OUT NOCOPY igf_lookups_view.meaning%TYPE)
2872: IS
2873: