APPS.PAY_EOSURVEY_PKG dependencies on PER_JOBS

Line 159: per_jobs pj,

155: pj.job_information1 job_category,
156: paf.assignment_status_type_id
157: ,'APPLICANT'
158: FROM per_assignments_f paf,
159: per_jobs pj,
160: per_assignment_status_types past,
161: fnd_common_lookups fcl
162: WHERE paf.assignment_status_type_id = past.assignment_status_type_id
163: AND --((

Line 197: ,per_jobs pj

193: FROM per_people_f ppf
194: ,per_assignments_f paf
195: ,per_periods_of_service pps
196: ,per_person_types ppt
197: ,per_jobs pj
198: ,fnd_common_lookups fcl
199: WHERE pps.person_id = paf.person_id
200: and pps.actual_termination_date is not null
201: and pps.actual_termination_date

Line 243: ,per_jobs pj -- BUG4434130

239: ,pj.job_information1 job_category -- BUG4434130
240: from per_people_f ppf
241: ,per_person_types ppt
242: ,per_assignments_f paf -- BUG4434130
243: ,per_jobs pj -- BUG4434130
244: where ppf.effective_start_date <= l_period_end
245: and ppf.effective_end_date >= l_period_start
246: and ppf.person_type_id = ppt.person_type_id
247: -- and ppt.system_person_type not in ( 'EMP_APL','EMP')

Line 273: ,per_jobs pj

269: ,pj.job_information1 job_category
270: from per_people_f ppf
271: ,per_periods_of_service pps
272: ,per_assignments_f paf
273: ,per_jobs pj
274: where ppf.person_id = l_person_id
275: and pps.person_id = ppf.person_id
276: and pps.actual_termination_date is not null
277: and pps.actual_termination_date between

Line 744: per_jobs pj,

740: ,paf.assignment_id
741: ,paf.effective_start_date
742: ,paf.effective_end_date
743: FROM per_assignments_f paf,
744: per_jobs pj,
745: fnd_common_lookups fcl
746: WHERE paf.person_id =l_person_id
747: AND pj.job_id = paf.job_id
748: AND ( ( paf.assignment_type = 'A'