136:
137: CURSOR Transfer_Block IS
138: --changes for Bug 8876216
139: /* SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
140: FROM pay_assignment_actions paa
141: WHERE paa.payroll_action_id =
142: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');*/
143:
144: SELECT 'TRANSFER_ACT_ID=P', mt.assignment_action_id
145: from hr_organization_units hou
146: , hr_locations_all hl
147: , per_periods_of_service pps
148: , per_assignments_f paf
149: , pay_assignment_actions mt
150: , pay_payroll_actions ppa
151: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
152: and mt.payroll_action_id = ppa.payroll_action_id
153: and paf.assignment_id = mt.assignment_id