82: --
83: cursor c1 is
84: select a.full_name, a.sex
85: from per_all_people_f a,
86: per_all_assignments_f b,
87: per_vacancies c
88: where a.business_group_id = b.business_group_id
89: and a.person_id = b.person_id
90: and trunc(sysdate)
159: --
160: cursor c2 is
161: select a.full_name
162: from per_all_people_f a,
163: per_all_assignments_f b,
164: per_vacancies c
165: where a.business_group_id = b.business_group_id
166: and a.person_id = b.person_id
167: and trunc(sysdate)
244: --
245: cursor c3 is
246: select a.full_name, a.sex
247: from per_all_people_f a,
248: per_all_assignments_f b,
249: per_vacancies c
250: where a.business_group_id = b.business_group_id
251: and a.person_id = b.person_id
252: and trunc(sysdate)