DBA Data[Home] [Help]

APPS.IGS_PR_COHINST_RANK_PKG dependencies on IGS_PE_PERSON

Line 630: CURSOR c_pers (cp_person_id igs_pe_person.person_id%TYPE) IS

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;

Line 632: FROM igs_pe_person_base_v

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: