7151: (c_system_person_type per_person_types.system_person_type%TYPE
7152: )
7153: is
7154: select null
7155: from sys.dual
7156: where exists
7157: (select null
7158: from per_all_people_f ppf,
7159: per_person_types ppt
9419: and ppt.person_type_id = ppf.person_type_id;
9420: --
9421: cursor csr_chk_future_changes is
9422: select null
9423: from sys.dual
9424: where exists(select null
9425: from per_all_people_f ppf
9426: , per_person_types ppt
9427: where ppf.effective_start_date between