[Home] [Help]
149: --while the person ID IS NULL
150: CURSOR alternate_person_id_cur(c_api_person_id igs_ad_recrt_pi_int.api_person_id%TYPE,
151: c_person_id_type igs_ad_recrt_pi_int.person_id_type%TYPE) IS
152: SELECT pe_person_id
153: FROM igs_pe_person_id_type_v
154: WHERE api_person_id = c_api_person_id AND
155: person_id_type = c_person_id_type ;
156:
157: --Cursor to check whether the person is valid