APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on FND_DATE

Line 233: fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);

229: , 'lr_parameter_info.EFF_START_DATE '
230: || lr_parameter_info.eff_start_date
231: );
232: p_start_date :=
233: fnd_date.canonical_to_date (lr_parameter_info.eff_start_date);
234: fnd_file.put_line (fnd_file.LOG
235: , 'lr_parameter_info.EFF_END_DATE '
236: || lr_parameter_info.eff_end_date
237: );

Line 239: fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);

235: , 'lr_parameter_info.EFF_END_DATE '
236: || lr_parameter_info.eff_end_date
237: );
238: p_end_date :=
239: fnd_date.canonical_to_date (lr_parameter_info.eff_end_date);
240: fnd_file.put_line (fnd_file.LOG
241: , 'lr_parameter_info.Effective_date '
242: || lr_parameter_info.effective_date
243: );

Line 405: , p_action_information5 => fnd_date.date_to_canonical

401: , p_action_information1 => 'PYSEHPDA'
402: , p_action_information2 => l_legal_employer_details.legal_employer_name
403: , p_action_information3 => g_legal_employer_id
404: , p_action_information4 => g_request_for
405: , p_action_information5 => fnd_date.date_to_canonical
406: (g_start_date)
407: , p_action_information6 => fnd_date.date_to_canonical
408: (g_end_date)
409: , p_action_information7 => NULL

Line 407: , p_action_information6 => fnd_date.date_to_canonical

403: , p_action_information3 => g_legal_employer_id
404: , p_action_information4 => g_request_for
405: , p_action_information5 => fnd_date.date_to_canonical
406: (g_start_date)
407: , p_action_information6 => fnd_date.date_to_canonical
408: (g_end_date)
409: , p_action_information7 => NULL
410: , p_action_information8 => NULL
411: , p_action_information9 => NULL

Line 1565: (fnd_date.canonical_to_date (action_information5)

1561: csr_v_pa_id pay_action_information.action_context_id%TYPE
1562: )
1563: IS
1564: SELECT TO_CHAR
1565: (fnd_date.canonical_to_date (action_information5)
1566: , 'YYYYMMDD'
1567: ) period_from
1568: , TO_CHAR
1569: (fnd_date.canonical_to_date (action_information6)

Line 1569: (fnd_date.canonical_to_date (action_information6)

1565: (fnd_date.canonical_to_date (action_information5)
1566: , 'YYYYMMDD'
1567: ) period_from
1568: , TO_CHAR
1569: (fnd_date.canonical_to_date (action_information6)
1570: , 'YYYYMMDD'
1571: ) period_to
1572: FROM pay_action_information
1573: WHERE action_context_type = 'PA'