APPS.IGF_GR_PELL_CALC dependencies on IGF_AW_COA_ITEMS

Line 712: FROM igf_aw_coa_items aci,

708: IS
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');

Line 726: FROM igf_aw_coa_items aci

722: IS
723: SELECT
724: NVL(SUM(aci.pell_coa_amount),0) reg_pell_coa,
725: NVL(SUM(aci.alt_pell_amount),0) alt_pell_coa
726: FROM igf_aw_coa_items aci
727: WHERE aci.base_id = l_base_id;
728:
729:
730: c_pell_coa_rec c_pell_coa%ROWTYPE;