APPS.PQH_WF dependencies on PER_ALL_ASSIGNMENTS

Line 2720: FROM per_all_assignments asg

2716: AND nvl(default_role,'X') = 'Y';
2717:
2718: cursor c_get_assignment (p_user_id NUMBER) IS
2719: SELECT asg.assignment_id,asg.position_id
2720: FROM per_all_assignments asg
2721: , fnd_user fu
2722: WHERE asg.person_id = fu.employee_id
2723: AND fu.user_id = p_user_id
2724: AND asg.primary_flag = 'Y';

Line 2728: FROM per_all_assignments asg

2724: AND asg.primary_flag = 'Y';
2725:
2726: cursor c_get_pos_role(p_assignment_id number) is
2727: SELECT rls.role_id
2728: FROM per_all_assignments asg
2729: , pqh_position_roles_v rls
2730: WHERE asg.position_id = rls.position_id;
2731:
2732: BEGIN

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 ;