672: and paf.person_id = p_person_id
673: and paf.assignment_status_type_id = pat.assignment_status_type_id(+)
674: and pat.per_system_status(+) = 'ACTIVE_ASSIGN'
675: and p_effective_date between paf.effective_start_date and paf.effective_end_date
676: and hr_security.show_record ('PER_ALL_ASSIGNMENTS_F',
677: paf.assignment_id,
678: paf.person_id,
679: paf.assignment_type
680: )
696: begin
697: --
698: hr_utility.set_location('Entering:'||l_proc, 5);
699: -- Perf changes
700: if hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y'
701: then
702: open c_all_assignment;
703: --
704: fetch c_all_assignment into l_assignment_id;