186: paf.effective_end_date
187: from
188: per_assignments_f paf,
189: pay_assignment_actions paa,
190: pay_population_ranges ppr
191: where
192: -- paf.person_id >= stperson and
193: -- paf.person_id <= endperson and
194: ppr.payroll_action_id = pactid and
245: paf.effective_end_date
246: from
247: per_assignments_f paf,
248: pay_assignment_actions paa,
249: pay_population_ranges ppr,
250: per_periods_of_service PDS
251: where
252: -- paf.person_id >= stperson and
253: -- paf.person_id <= endperson and
366: paf.effective_end_date
367: from
368: per_assignments_f paf,
369: pay_assignment_actions paa,
370: pay_population_ranges ppr
371: where
372: -- paf.person_id >= stperson and
373: -- paf.person_id <= endperson and
374: ppr.payroll_action_id = pactid and
435: paf.effective_end_date
436: from
437: per_assignments_f paf,
438: pay_assignment_actions paa,
439: pay_population_ranges ppr,
440: per_periods_of_service pds
441: where
442: -- paf.person_id >= stperson and
443: -- paf.person_id <= endperson and