[Home] [Help]
41: -- ,per_assignment_status_types past
42: -- ,per_person_types ppt
43: WHERE ptoa.object_id = paaf.assignment_id
44: AND paaf.person_id = papf.person_id
45: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
46: AND ptoa.payroll_action_id = ppa.payroll_action_id
47: -- AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
48: -- AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
49: -- AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
105: --
106:
107: CURSOR csr_curr_act IS
108: SELECT 'TRANSFER_ACT_ID=P',
109: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
110: FROM DUAL;
111: --
112: PROCEDURE xml_header;
113: --