1000: from pay_assignment_actions paa,
1001: per_all_assignments_f paf,
1002: per_all_people_f ppf,
1003: pay_payroll_actions ppa,
1004: pay_action_classifications pac
1005: where ppf.person_id = cp_person_id
1006: and paf.person_id = ppf.person_id
1007: and paa.assignment_id = paf.assignment_id
1008: and paa.tax_unit_id = cp_tax_unit_id
2030: from pay_assignment_actions paa,
2031: per_all_assignments_f paf,
2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,
2035: pay_action_contexts pac1,
2036: ff_contexts fc
2037: where ppf.person_id = cp_person_id
2038: and paf.person_id = ppf.person_id