APPS.PQH_WF dependencies on PER_ALL_PEOPLE_F

Line 2927: from per_all_people_f per, fnd_user usr

2923: end;
2924: function get_person_name(p_user_id in number default null,
2925: p_assignment_id in number default null) return varchar2 is
2926: cursor c1 is select full_name
2927: from per_all_people_f per, fnd_user usr
2928: where per.person_id = usr.employee_id
2929: and usr.user_id = p_user_id;
2930: cursor c2 is select full_name
2931: from per_all_assignments_f asg, per_all_people_f per

Line 2931: from per_all_assignments_f asg, per_all_people_f per

2927: from per_all_people_f per, fnd_user usr
2928: where per.person_id = usr.employee_id
2929: and usr.user_id = p_user_id;
2930: cursor c2 is select full_name
2931: from per_all_assignments_f asg, per_all_people_f per
2932: where asg.person_id = per.person_id
2933: and sysdate between asg.effective_start_date and asg.effective_end_date
2934: and sysdate between per.effective_start_date and per.effective_end_date
2935: and asg.assignment_id = p_assignment_id ;