DBA Data[Home] [Help]

APPS.PAY_SG_CPFLINE_BALANCES dependencies on FND_DATE

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

366: pai.action_information22,
367: paa.assignment_id,
368: paa.assignment_action_id,
369: pai.tax_unit_id,
370: fnd_date.canonical_to_date(pai.action_information20),
371: pai.action_information19
372: from pay_payroll_actions ppa
373: , pay_assignment_actions paa
374: , pay_action_information pai

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

404: pai.action_information22,
405: paa.assignment_id,
406: paa.assignment_action_id,
407: pai.tax_unit_id,
408: fnd_date.canonical_to_date(pai.action_information20),
409: pai.action_information19
410: from pay_payroll_actions ppa
411: , pay_assignment_actions paa
412: , pay_action_information pai

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

800: if mf_employee_info = 'X' then
801: l_date:= to_date('01/01/1900','dd/mm/yyyy');
802: mf_employee_info:= to_char(l_date,'dd/mm/yyyy');
803: else
804: l_date:= fnd_date.canonical_to_date(mf_employee_info);
805: mf_employee_info:= to_char(l_date,'dd/mm/yyyy');
806: end if;
807: --
808: return mf_employee_info;