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
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
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
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: --
140: assignment_id = p_assignment_id
141: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
142: and aei_information7 = p_recipient_reg_no
143: and aei_information8 <> p_recipient_name
144: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
145: --
146: Cursor csr_don_totals1 is
147: select aei_information18, -- Statutory
148: aei_information20, -- Political
152: from per_assignment_extra_info pai
153: where
154: pai.assignment_id = p_assignment_id
155: and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
156: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
157: trunc(p_effective_date, 'YYYY');
158: --
159: Cursor csr_don_totals2 is
160: select aei_information4, -- Promotional Fund
164: from per_assignment_extra_info pai
165: where
166: pai.assignment_id = p_assignment_id
167: and pai.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
168: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') =
169: trunc(p_effective_date, 'YYYY');
170: --
171: l_dup_found varchar2(1) ;
172: --
228: from ff_globals_f glb
229: where glb.global_name = p_glbvar
230: and l_effective_date between glb.effective_start_date and glb.effective_end_date;
231: begin
232: l_effective_date := fnd_date.canonical_to_date(p_effective_date) ;
233:
234: OPEN csr_ff_global('KR_YEA_POLITICAL_DONATION_TAX_BREAK_LIM');
235: FETCH csr_ff_global into l_political_tax_brk_lim2004;
236: CLOSE csr_ff_global;