[Home] [Help]
1689: from
1690: per_periods_of_service pos,
1691: per_all_assignments_f paf,
1692: pay_payroll_actions ppa,
1693: pay_population_ranges ppr
1694: where ppr.chunk_number = c_chunk
1695: and ppr.payroll_action_id = ppa.payroll_action_id
1696: and pos.person_id = ppr.person_id
1697: and pos.person_id = paf.person_id
1764: ( select distinct paf.assignment_id from
1765: per_periods_of_service pos,
1766: per_all_assignments_f paf,
1767: pay_payroll_actions ppa,
1768: pay_population_ranges ppr
1769: where ppr.chunk_number = p_chunk
1770: and ppr.payroll_action_id = ppa.payroll_action_id
1771: and pos.person_id = ppr.person_id
1772: and pos.person_id = paf.person_id
1798: ( select distinct paf.assignment_id from
1799: per_periods_of_service pos,
1800: per_all_assignments_f paf,
1801: pay_payroll_actions ppa,
1802: pay_population_ranges ppr
1803: where pos.person_id between p_start_person_id and p_end_person_id
1804: and ppr.payroll_action_id = ppa.payroll_action_id
1805: and pos.person_id = paf.person_id
1806: and pos.period_of_service_id = paf.period_of_service_id