[Home] [Help]
2219: -- Student should be having at least one loan award in his student life.
2220: -- so person id was used to check the existance in diferent awd years
2221: CURSOR c_nslds ( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ) IS
2222: SELECT 'x'
2223: FROM igf_ap_nslds_data nslds,
2224: igf_ap_fa_base_rec_all fabase
2225: WHERE fabase.base_id = nslds.base_id AND
2226: fabase.person_id = cp_person_id AND
2227: nslds.nslds_loan_prog_code_1 IS NOT NULL;