387: ,pay_action_information pai
388: ,pay_assignment_Actions paa
389: ,pay_payroll_actions ppa
390: ,hr_lookups hrl
391: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
392: AND ptoa.object_id = paa.assignment_id
393: AND paa.payroll_action_id = ppa.payroll_action_id
394: AND ppa.effective_Date BETWEEN c_start_date
395: AND c_end_date
406: --
407: BEGIN
408: --hr_utility.trace('###### IN XML_ASG');
409: --
410: l_actid := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
411: --
412: get_all_parameters(l_actid
413: ,l_payroll_id
414: ,l_consolidation_set_id