[Home] [Help]
709: SELECT
710: NVL(SUM(aci.pell_coa_amount),0) reg_pell_coa,
711: NVL(SUM(aci.alt_pell_amount),0) alt_pell_coa
712: FROM igf_aw_coa_items aci,
713: igf_aw_item ai
714: WHERE aci.base_id = l_base_id
715: AND aci.item_code = ai.item_code
716: AND ai.item_category_code IN ('TUITION','BOOKS','FEES','TRANSPORTATION','SUPPLIES','DEPENDENT_CARE');
717: