APPS.IGF_AW_GEN_003 dependencies on IGF_SE_AUTH

Line 4037: FROM igf_se_auth

4033: -- check if award has pell or loan record
4034: --
4035: CURSOR cur_fws_awd (p_award_id igf_aw_award_all.award_id%TYPE) IS
4036: SELECT COUNT(auth_id) awd_count
4037: FROM igf_se_auth
4038: WHERE award_id = p_award_id
4039: AND flag = 'A';
4040:
4041: fws_awd_rec cur_fws_awd%ROWTYPE;

Line 4165: fnd_message.set_name('IGF','IGF_SE_AUTH_OR_PAID_PRSNT');

4161: FETCH cur_fws_awd INTO fws_awd_rec;
4162: CLOSE cur_fws_awd;
4163:
4164: IF fws_awd_rec.awd_count > 0 THEN
4165: fnd_message.set_name('IGF','IGF_SE_AUTH_OR_PAID_PRSNT');
4166: lv_message := fnd_message.get;
4167: RETURN lv_message;
4168: END IF;
4169: