DBA Data[Home] [Help]

APPS.PER_GENERIC_REPORT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: per_all_assignments_f b,

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
90: and trunc(sysdate)

Line 163: per_all_assignments_f b,

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
167: and trunc(sysdate)

Line 248: per_all_assignments_f b,

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
252: and trunc(sysdate)