[Home] [Help]
93: ppf.full_name,
94: paf.assignment_number
95: FROM
96: hr_organization_units hou,
97: hr_soft_coding_keyflex hsck,
98: per_people_f ppf,
99: per_assignments_f paf
100: WHERE
101: paf.assignment_id = p_assignment_id
261: /* If it is then, we do not want to process the record */
262:
263:
264: cursor csr_get_employee (p_loc_id number) is
265: select /*+ index(hsck HR_SOFT_CODING_KEYFLEX_PK) */ paf.assignment_id assignment_id,
266: paf.person_id,
267: max(paf.effective_end_date) effective_end_date,
268: min(paf.effective_start_date) effective_start_date,
269: paf.business_group_id,
268: min(paf.effective_start_date) effective_start_date,
269: paf.business_group_id,
270: paf.assignment_type
271: from per_all_assignments_f paf,
272: hr_soft_coding_keyflex hsck
273: where (paf.location_id = p_loc_id
274: or hsck.segment18 = to_char(p_loc_id)) -- #3056158
275: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
276: group by assignment_id,
285: hsck.segment18,
286: paf.effective_start_date,
287: paf.effective_end_date
288: from per_all_assignments_f paf,
289: hr_soft_coding_keyflex hsck
290: where paf.assignment_id = p_assignment_id
291: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
292: and effective_start_date >= p_def_date
293: order by effective_start_date;