110: cursor c1 is
111: SELECT NULL
112: FROM per_people_f ppf,
113: per_person_type_usages_f ptu, 114: per_person_types ppt 115: WHERE ppf.person_id = p_person_id
116: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
117: AND ppf.person_id = ptu.person_id
118: AND TRUNC (SYSDATE) BETWEEN ptu.effective_start_date AND ptu.effective_end_date