DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE_BALANCES dependencies on FND_DATE

Line 378: fnd_date.canonical_to_date(pai.action_information20),

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

Line 416: fnd_date.canonical_to_date(pai.action_information20),

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

Line 812: l_date:= fnd_date.canonical_to_date(mf_employee_info);

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;