3: level_cnt NUMBER;
4: CURSOR csr_header
5: IS
6: SELECT 'REPORTED_DATE=P',
7: pay_magtape_generic.get_parameter_value('REPORTED_DATE'),
8: 'CONCATENATED_BP_NAMES=P',
9: pay_kr_hia_func_pkg.get_concat_bp_names(
10: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
11: pay_magtape_generic.get_parameter_value('BP_HI_NUMBER'),
6: SELECT 'REPORTED_DATE=P',
7: pay_magtape_generic.get_parameter_value('REPORTED_DATE'),
8: 'CONCATENATED_BP_NAMES=P',
9: pay_kr_hia_func_pkg.get_concat_bp_names(
10: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
11: pay_magtape_generic.get_parameter_value('BP_HI_NUMBER'),
12: 94)
13: FROM dual;
14:
7: pay_magtape_generic.get_parameter_value('REPORTED_DATE'),
8: 'CONCATENATED_BP_NAMES=P',
9: pay_kr_hia_func_pkg.get_concat_bp_names(
10: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
11: pay_magtape_generic.get_parameter_value('BP_HI_NUMBER'),
12: 94)
13: FROM dual;
14:
15: CURSOR csr_data(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')))
11: pay_magtape_generic.get_parameter_value('BP_HI_NUMBER'),
12: 94)
13: FROM dual;
14:
15: CURSOR csr_data(p_payroll_action_id number default to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')))
16: IS
17: SELECT 'ASSIGNMENT_ACTION_ID=C',
18: to_char(paa.assignment_action_id),
19: 'HI_NUMBER=P',