DBA Data[Home] [Help]

APPS.PER_GENERIC_REPORT_PKG dependencies on PER_ALL_PEOPLE_F

Line 85: from per_all_people_f a,

81: -- p_param_1.
82: --
83: cursor c1 is
84: select a.full_name, a.sex
85: from per_all_people_f a,
86: per_all_assignments_f b,
87: per_vacancies c
88: where a.business_group_id = b.business_group_id
89: and a.person_id = b.person_id

Line 162: from per_all_people_f a,

158: -- on the value of p_param_2.
159: --
160: cursor c2 is
161: select a.full_name
162: from per_all_people_f a,
163: per_all_assignments_f b,
164: per_vacancies c
165: where a.business_group_id = b.business_group_id
166: and a.person_id = b.person_id

Line 247: from per_all_people_f a,

243: -- dependant on the value of p_param_3.
244: --
245: cursor c3 is
246: select a.full_name, a.sex
247: from per_all_people_f a,
248: per_all_assignments_f b,
249: per_vacancies c
250: where a.business_group_id = b.business_group_id
251: and a.person_id = b.person_id