289: where p_person_type = system_person_type;
290: --
291: cursor check_person_id is
292: select person_id
293: from per_all_people_f
294: where person_id = p_person_id;
295: --
296: cursor current_person_type is
297: select 'Y'
378: where p_person_type = system_person_type;
379: --
380: cursor check_person_id is
381: select person_id
382: from per_all_people_f
383: where person_id = p_person_id;
384: --
385: cursor check_person_ex_type is
386: select 'Y'