478: l_person_id number(15);
479:
480: CURSOR c_person_awd_status (cp_base_id NUMBER) IS
481: SELECT fa.lock_awd_flag
482: FROM igf_ap_fa_base_rec fa
483: WHERE fa.base_id = cp_base_id;
484:
485: l_person_awd_status igf_ap_fa_base_rec.lock_awd_flag%TYPE;
486:
481: SELECT fa.lock_awd_flag
482: FROM igf_ap_fa_base_rec fa
483: WHERE fa.base_id = cp_base_id;
484:
485: l_person_awd_status igf_ap_fa_base_rec.lock_awd_flag%TYPE;
486:
487: lb_has_offered BOOLEAN; -- Place holder for Offered award status : Scope - local
488: lb_has_accepted BOOLEAN; -- Place holder for Accepted award status : Scope - local
489: lb_has_declined BOOLEAN; -- Place holder for Declined award status : Scope - local