374: pai.action_information22,
375: paa.assignment_id,
376: paa.assignment_action_id,
377: pai.tax_unit_id,
378: fnd_date.canonical_to_date(pai.action_information20),
379: pai.action_information19
380: from pay_payroll_actions ppa
381: , pay_assignment_actions paa
382: , pay_action_information pai
412: pai.action_information22,
413: paa.assignment_id,
414: paa.assignment_action_id,
415: pai.tax_unit_id,
416: fnd_date.canonical_to_date(pai.action_information20),
417: pai.action_information19
418: from pay_payroll_actions ppa
419: , pay_assignment_actions paa
420: , pay_action_information pai
808: if mf_employee_info = 'X' then
809: l_date:= to_date('01/01/1900','dd/mm/yyyy');
810: mf_employee_info:= to_char(l_date,'dd/mm/yyyy');
811: else
812: l_date:= fnd_date.canonical_to_date(mf_employee_info);
813: mf_employee_info:= to_char(l_date,'dd/mm/yyyy');
814: end if;
815: --
816: return mf_employee_info;