132: ,pay_element_entries_f ee
133: ,pay_element_entry_values_f eev1
134: ,pay_assignment_actions pac
135: ,fnd_sessions fs
136: ,pay_input_values_f_tl ivtl
137: WHERE per.person_id = asg1.person_id
138: AND asg2.person_id = per.person_id
139: AND asg2.primary_flag = 'Y'
140: AND et.element_name = 'Wage Attachment Support Order'
179: ,pay_element_entries_f ee
180: ,pay_element_entry_values_f eev1
181: ,pay_assignment_actions pac
182: ,fnd_sessions fs
183: ,pay_input_values_f_tl ivtl
184: WHERE per.person_id = asg1.person_id
185: AND asg2.person_id = per.person_id
186: AND asg2.primary_flag = 'Y'
187: AND et.element_name = 'Wage Attachment Tax Levy'
228: ,pay_element_entries_f ee
229: ,pay_element_entry_values_f eev1
230: ,pay_assignment_actions pac
231: ,fnd_sessions fs
232: ,pay_input_values_f_tl ivtl
233: WHERE per.person_id = asg1.person_id
234: AND asg2.person_id = per.person_id
235: AND asg2.primary_flag = 'Y'
236: AND et.element_name = 'Union Dues'
274: ,pay_element_entries_f ee
275: ,pay_element_entry_values_f eev1
276: ,pay_assignment_actions pac
277: ,fnd_sessions fs
278: ,pay_input_values_f_tl ivtl
279: WHERE per.person_id = asg1.person_id
280: AND asg2.person_id = per.person_id
281: AND asg2.primary_flag = 'Y'
282: AND et.element_name = p_element_name