[Home] [Help]
191: ,paf.assignment_status_type_id
192: ,ppt.system_person_type
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
267: ,ppf.sex sex
268: ,'EX_EMP' person_type
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
319: select ppf.per_information1 race_code,
320: ppt.system_person_type person_type
321: from per_people_f ppf
322: ,per_person_types ppt
323: ,per_periods_of_service pps
324: where ppf.effective_start_date <= l_period_end
325: and ppf.effective_end_date >= l_period_start
326: and ppf.per_information1 is not NULL
327: and ppf.person_type_id = ppt.person_type_id
696: ppf.per_information1 race,
697: ppf.person_type_id,pps.date_start service_start
698: FROM per_people_f ppf,
699: per_person_types ppt,
700: per_periods_of_service pps
701: WHERE ( ( ppt.system_person_type = 'EMP'
702: /* BUG4434130
703: and ppf.effective_start_date
704: = (select max(ppf1.effective_start_date)
1212: ,p_end_date in date)
1213: is
1214: select 1
1215: from per_people_f ppf
1216: ,per_periods_of_service pps
1217: where ppf.person_id = p_person_id
1218: and ppf.effective_start_date < p_end_date
1219: and ppf.effective_end_date > p_start_date
1220: and pps.person_id = ppf.person_id
1239: ppf.effective_end_date eff_end,
1240: ppf.per_information1 race
1241: FROM per_people_f ppf,
1242: per_person_types ppt,
1243: per_periods_of_service pps
1244: WHERE ( ( ppt.system_person_type = 'EMP'
1245: and ppf.effective_start_date
1246: = (select max(effective_start_date)
1247: from per_people_f