APPS.PER_KR_EXTRA_AEI_RULES dependencies on FND_DATE

Line 30: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY'));

26: from per_assignment_extra_info
27: where assignment_id = p_assignment_id
28: and assignment_extra_info_id <> p_assignment_extra_info_id
29: and information_type = p_information_type
30: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY'));
31: begin
32: if p_information_type in ('KR_YEA_SP_TAX_EXEM_INFO',
33: 'KR_YEA_TAX_EXEM_INFO',
34: 'KR_YEA_TAX_BREAK_INFO',

Line 36: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);

32: if p_information_type in ('KR_YEA_SP_TAX_EXEM_INFO',
33: 'KR_YEA_TAX_EXEM_INFO',
34: 'KR_YEA_TAX_BREAK_INFO',
35: 'KR_YEA_OVS_TAX_BREAK_INFO') then
36: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
37: --
38: -- Lock first assignment record in this calendar year
39: -- to guarantee uniqueness.
40: --