DBA Data[Home] [Help]

APPS.PER_QP_INVOCATIONS dependencies on PER_PEOPLE

Line 95: from per_people p

91: cursor c2 is
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

Line 317: , per_people p

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)
321: or (p_assignment_number is not null