[Home] [Help]
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
200: and pps.actual_termination_date is not null
237: ,ppf.sex sex
238: ,ppt.system_person_type person_type
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
318: is
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
695: ppf.effective_end_date eff_end,
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
729: and pps.person_id = ppf.person_id;
730:
731: CURSOR assignment_details(l_person_id per_people_f.person_id%TYPE,
732: l_location_id per_assignments_f.location_id%TYPE,
733: l_person_type per_person_types.system_person_type%TYPE,
734: l_period_start date,
735: l_period_end date)
736: IS
737: SELECT distinct paf.person_id,
1238: ppf.effective_start_Date eff_Start,
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)