50: --
51: /*
52: CURSOR c_body IS
53: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
54: FROM pay_assignment_actions paa
55: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
56: ('TRANSFER_PAYROLL_ACTION_ID'))
57: ORDER BY paa.assignment_action_id;
58: */
58: */
59:
60: CURSOR c_body IS
61: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
62: FROM pay_assignment_actions paa,
63: pay_action_information pai
64: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
65: ('TRANSFER_PAYROLL_ACTION_ID'))
66: and paa.assignment_action_id=pai.action_context_id