22: --
23: CURSOR eas_header IS
24:
25: select 'PAYROLL_ACTION_ID=P',
26: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
27: from dual;
28:
29: CURSOR eas_employee IS
30: select
34: paa.assignment_id,
35: 'TRANSFER_ACT_ID=P',
36: paa.assignment_action_id
37: from pay_assignment_actions paa
38: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
39:
40: CURSOR eas_asg_actions IS
41: select
42: 'TRANSFER_ACT_ID=P',
39:
40: CURSOR eas_asg_actions IS
41: select
42: 'TRANSFER_ACT_ID=P',
43: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
44: from dual;
45: --
46: CURSOR nino_header IS
47:
45: --
46: CURSOR nino_header IS
47:
48: select 'PAYROLL_ACTION_ID=P',
49: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
50: from dual;
51:
52: CURSOR nino_employee IS
53: select
57: paa.assignment_id,
58: 'TRANSFER_ACT_ID=P',
59: paa.assignment_action_id
60: from pay_assignment_actions paa
61: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
62:
63: CURSOR nino_asg_actions IS
64: select
65: 'TRANSFER_ACT_ID=P',
62:
63: CURSOR nino_asg_actions IS
64: select
65: 'TRANSFER_ACT_ID=P',
66: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
67: from dual;
68: --
69: level_cnt number;
70: --