[Home] [Help]
104: where par.pa_request_id = p_pa_request_rec.pa_request_id;
105:
106: Cursor c_per_type is
107: Select ppt.system_person_type
108: from per_people_f per,
109: per_person_types ppt
110: where per.person_id = p_pa_request_rec.person_id
111: and p_pa_request_rec.effective_date
112: between per.effective_start_date and per.effective_end_date