APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on FND_DATE

Line 66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER

62: ) IS
63: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
64: SELECT PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,
65: 'LEGAL_EMPLOYER')
66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
67: (legislative_parameters,'START_DATE'))
68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
69: (legislative_parameters,'END_DATE'))
70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER

64: SELECT PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,
65: 'LEGAL_EMPLOYER')
66: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
67: (legislative_parameters,'START_DATE'))
68: ,FND_DATE.canonical_to_date(PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER
69: (legislative_parameters,'END_DATE'))
70: ,PAY_NO_ARCHIVE_ABSENCE.GET_PARAMETER(legislative_parameters,'ARCHIVE')
71: ,effective_date
72: ,business_group_id

Line 436: p_action_information3 => fnd_date.date_to_canonical(l_start_date),

432: p_source_text => NULL,
433: p_action_information_category=> 'EMEA REPORT DETAILS',
434: p_action_information1 => 'PYNOABSA',
435: p_action_information2 => l_legal_employer_id,
436: p_action_information3 => fnd_date.date_to_canonical(l_start_date),
437: p_action_information4 => fnd_date.date_to_canonical(l_end_date),
438: p_action_information5 => fnd_date.date_to_canonical(l_effective_date)
439: );
440:

Line 437: p_action_information4 => fnd_date.date_to_canonical(l_end_date),

433: p_action_information_category=> 'EMEA REPORT DETAILS',
434: p_action_information1 => 'PYNOABSA',
435: p_action_information2 => l_legal_employer_id,
436: p_action_information3 => fnd_date.date_to_canonical(l_start_date),
437: p_action_information4 => fnd_date.date_to_canonical(l_end_date),
438: p_action_information5 => fnd_date.date_to_canonical(l_effective_date)
439: );
440:
441: SELECT count(*) INTO l_count

Line 438: p_action_information5 => fnd_date.date_to_canonical(l_effective_date)

434: p_action_information1 => 'PYNOABSA',
435: p_action_information2 => l_legal_employer_id,
436: p_action_information3 => fnd_date.date_to_canonical(l_start_date),
437: p_action_information4 => fnd_date.date_to_canonical(l_end_date),
438: p_action_information5 => fnd_date.date_to_canonical(l_effective_date)
439: );
440:
441: SELECT count(*) INTO l_count
442: FROM pay_action_information