93: l_num_ids NUMBER := 0;
94:
95: CURSOR r_ids IS
96: SELECT person_id
97: FROM per_all_people_f
98: WHERE full_name = p_resource_name
99: AND trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date);
100:
101: CURSOR p_ids IS
205: l_num_ids NUMBER := NULL;
206:
207: CURSOR r_ids IS
208: SELECT person_id
209: FROM per_all_people_f
210: WHERE full_name = p_person_name;
211:
212: CURSOR login_id IS
213: SELECT employee_id