111: MAX(asg.payroll_id) payroll_id --9059957
112: FROM
113: per_all_people_f pap,
114: per_all_assignments_f asg,
115: pay_payroll_actions ppa,
116: pay_assignment_actions paa,
117: pay_run_results prr,
118: pay_element_types_f pet
119: WHERE pap.person_id = asg.person_id
149: max(paa.assignment_action_id) assignment_action_id
150: FROM
151: per_all_people_f pap,
152: per_all_assignments_f asg,
153: pay_payroll_actions ppa,
154: pay_assignment_actions paa,
155: pay_run_results prr
156: WHERE pap.person_id = asg.person_id
157: AND pap.current_employee_flag = 'Y'
171: AND NOT EXISTS (
172: SELECT
173: 1
174: FROM
175: pay_payroll_actions ppa1,
176: pay_assignment_actions paa1,
177: pay_run_results prr1,
178: pay_element_types_f pet
179: WHERE pet.legislation_code = 'DK'
226: ) IS
227: SELECT
228: max(paa.assignment_action_id) assignment_action_id
229: FROM
230: pay_payroll_actions ppa,
231: pay_assignment_actions paa
232: WHERE paa.assignment_id = p_assignment_id
233: AND paa.tax_unit_id = p_legal_employer_id
234: AND ppa.payroll_action_id = paa.payroll_action_id