APPS.PQH_WF dependencies on PER_ALL_ASSIGNMENTS

Line 2726: FROM per_all_assignments asg

2722: AND nvl(default_role,'X') = 'Y';
2723:
2724: cursor c_get_assignment (p_user_id NUMBER) IS
2725: SELECT asg.assignment_id,asg.position_id
2726: FROM per_all_assignments asg
2727: , fnd_user fu
2728: WHERE asg.person_id = fu.employee_id
2729: AND fu.user_id = p_user_id
2730: AND asg.primary_flag = 'Y'

Line 2735: FROM per_all_assignments asg

2731: AND asg.assignment_type = 'E'; -- added for bug 7708168
2732:
2733: cursor c_get_pos_role(p_assignment_id number) is
2734: SELECT rls.role_id
2735: FROM per_all_assignments asg
2736: , pqh_position_roles_v rls
2737: WHERE asg.position_id = rls.position_id;
2738:
2739: BEGIN

Line 2945: from per_all_assignments_f asg, per_all_people_f per

2941: from per_all_people_f per, fnd_user usr
2942: where per.person_id = usr.employee_id
2943: and usr.user_id = p_user_id;
2944: cursor c2 is select full_name
2945: from per_all_assignments_f asg, per_all_people_f per
2946: where asg.person_id = per.person_id
2947: and sysdate between asg.effective_start_date and asg.effective_end_date
2948: and sysdate between per.effective_start_date and per.effective_end_date
2949: and asg.assignment_id = p_assignment_id ;