128: /*Cursor to get the person type of the given person id*/
129: CURSOR c_person_type IS
130: SELECT 'X'
131: FROM per_person_types ppt,
132: per_person_type_usages_f pptu
133: WHERE ppt.person_type_id = pptu.person_type_id
134: AND ppt.business_group_id = p_business_group_id
135: AND pptu.person_id = p_person_id
136: AND p_effective_date BETWEEN pptu.effective_start_date