APPS.IGF_AW_GEN dependencies on IGF_AW_AWARD_T

Line 850: CURSOR c_pkg_tot ( x_base_id igf_aw_award_t.base_id%TYPE) IS

846: || avenkatr 27-JUN-2001 1. Added p_pack_status parameter.
847: */
848:
849: -- Sums up studentwise packaged totals
850: CURSOR c_pkg_tot ( x_base_id igf_aw_award_t.base_id%TYPE) IS
851: SELECT SUM(NVL(awd.offered_amt,0)) offered_amt,
852: SUM(NVL(awd.accepted_amt,0)) accepted_amt
853: FROM igf_aw_award awd
854: WHERE awd.base_id = x_base_id