APPS.PER_QP_INVOCATIONS dependencies on PER_ASSIGNMENTS_F

Line 96: , per_assignments_f a

92: select p.full_name
93: , a.assignment_number
94: , hr_person_type_usage_info.get_user_person_type(p_session_date,p.person_id)
95: from per_people p
96: , per_assignments_f a
97: where p.person_id = a.person_id
98: and a.assignment_id = p_invocation_context
99: and p_session_date between a.effective_start_date
100: and a.effective_end_date;

Line 316: from per_assignments_f a

312: ,p_assignment_number VARCHAR2) return NUMBER is
313: --
314: cursor c is
315: select a.assignment_id
316: from per_assignments_f a
317: , per_people p
318: where a.person_id = p.person_id
319: and ((p_assignment_number is null
320: and a.assignment_number is null)