150:
151:
152: CURSOR GET_CURR_ACT_ID IS
153: SELECT 'TRANSFER_ACT_ID=P',
154: pay_magtape_generic.get_parameter_value(
155: 'TRANSFER_ACT_ID')
156: FROM DUAL;
157:
158: CURSOR GET_XML_VER IS
158: CURSOR GET_XML_VER IS
159: SELECT 'ROOT_XML_TAG=P',
160: '
161: 'PAYROLL_ACTION_ID=P',
162: pay_magtape_generic.get_parameter_value(
163: 'TRANSFER_PAYROLL_ACTION_ID')
164: FROM dual;
165:
166: CURSOR GET_MAG_ASG_ACT IS
166: CURSOR GET_MAG_ASG_ACT IS
167: SELECT 'TRANSFER_ACT_ID=P',
168: assignment_action_id
169: FROM pay_assignment_actions
170: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value(
171: 'TRANSFER_PAYROLL_ACTION_ID');
172:
173:
174: END PER_MX_SS_AFFILIATION;