APPS.PAY_KR_YEA_FORM_PKG dependencies on FND_DATE

Line 31: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

27: assignment_id = p_assignment_id and
28: information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' and
29: aei_information5 = p_provider_reg_no and
30: aei_information6 <> p_provider_reg_name and
31: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
32: trunc(p_effective_date, 'YYYY');
33:
34: cursor csr_dup_relation_aged_disabled is
35: select

Line 43: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

39: where
40: assignment_id = p_assignment_id and
41: information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' and
42: aei_information8 = p_res_reg_no and
43: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
44: trunc(p_effective_date, 'YYYY');
45:
46: Cursor csr_medical_totals is
47: select aei_information24, -- employee

Line 55: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

51: from per_assignment_extra_info pai
52: where
53: pai.assignment_id = p_assignment_id and
54: pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO' and
55: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
56: trunc(p_effective_date, 'YYYY');
57: -- Bug 4704848
58: Cursor csr_total_card_exp is
59: select aei_information3 -- card expense

Line 64: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

60: from per_assignment_extra_info pai
61: where
62: pai.assignment_id = p_assignment_id and
63: pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2' and
64: trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
65: trunc(p_effective_date, 'YYYY');
66:
67: Begin
68: --

Line 143: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

139: assignment_id = p_assignment_id
140: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
141: and aei_information7 = p_recipient_reg_no
142: and aei_information8 <> p_recipient_name
143: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
144: --
145: Cursor csr_don_totals1 is
146: select aei_information18, -- Statutory
147: aei_information20, -- Political

Line 155: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

151: from per_assignment_extra_info pai
152: where
153: pai.assignment_id = p_assignment_id
154: and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
155: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
156: trunc(p_effective_date, 'YYYY');
157: --
158: Cursor csr_don_totals2 is
159: select aei_information4, -- Promotional Fund

Line 166: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =

162: from per_assignment_extra_info pai
163: where
164: pai.assignment_id = p_assignment_id
165: and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
166: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
167: trunc(p_effective_date, 'YYYY');
168: --
169: l_dup_found varchar2(1) ;
170: --

Line 229: l_effective_date := fnd_date.canonical_to_date(p_effective_date) ;

225: from ff_globals_f glb
226: where glb.global_name = p_glbvar
227: and l_effective_date between glb.effective_start_date and glb.effective_end_date;
228: begin
229: l_effective_date := fnd_date.canonical_to_date(p_effective_date) ;
230:
231: OPEN csr_ff_global('KR_YEA_POLITICAL_DONATION_TAX_BREAK_LIM');
232: FETCH csr_ff_global into l_political_tax_brk_lim2004;
233: CLOSE csr_ff_global;