626: -- raise business event whenever there is a change in override rank or override
627: -- rank is given
628: DECLARE
629: -- cursor to fetch person details
630: CURSOR c_pers (cp_person_id igs_pe_person.person_id%TYPE) IS
631: SELECT person_number, full_name
632: FROM igs_pe_person_base_v
633: WHERE person_id = cp_person_id;
634: rec_pers c_pers%ROWTYPE;
628: DECLARE
629: -- cursor to fetch person details
630: CURSOR c_pers (cp_person_id igs_pe_person.person_id%TYPE) IS
631: SELECT person_number, full_name
632: FROM igs_pe_person_base_v
633: WHERE person_id = cp_person_id;
634: rec_pers c_pers%ROWTYPE;
635: rec_admin c_pers%ROWTYPE;
636: