eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_PAYKRYRS_PKG dependencies on FND_DATE

Line 87: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

83: aei_information7
84: from per_assignment_extra_info
85: where assignment_id = p_assignment_id
86: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO3'
87: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
88: ------------------------- Other Exemptions Cursor -----------------------
89: cursor per_asg_extra_info_othr_csr(p_assignment_id number, p_year number) is
90: select aei_information3 pers_pen_prem
91: ,aei_information4 pers_pen_sav

Line 142: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,

138: cursor per_asg_extra_info_ovs_csr(p_assignment_id number, p_year number) is
139: select aei_information7 p_ovs_tax_paid_fc,
140: aei_information8 p_ovs_tax_paid_lc,
141: hr_general.decode_territory(aei_information2) p_ovs_country,
142: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,
143: to_char(fnd_date.canonical_to_date(aei_information10), 'YYYY.MM.DD') p_ovs_submit_date,
144: aei_information11 p_ovs_location,
145: aei_information12 p_ovs_period,
146: aei_information13 p_ovs_title

Line 143: to_char(fnd_date.canonical_to_date(aei_information10), 'YYYY.MM.DD') p_ovs_submit_date,

139: select aei_information7 p_ovs_tax_paid_fc,
140: aei_information8 p_ovs_tax_paid_lc,
141: hr_general.decode_territory(aei_information2) p_ovs_country,
142: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,
143: to_char(fnd_date.canonical_to_date(aei_information10), 'YYYY.MM.DD') p_ovs_submit_date,
144: aei_information11 p_ovs_location,
145: aei_information12 p_ovs_period,
146: aei_information13 p_ovs_title
147: from per_assignment_extra_info

Line 150: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

146: aei_information13 p_ovs_title
147: from per_assignment_extra_info
148: where assignment_id = p_assignment_id
149: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'
150: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
151:
152: ------------------------- FW Tax Break Cursor --------------------------
153: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
154: select aei_information1 p_immigration_purpose,

Line 155: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,

151:
152: ------------------------- FW Tax Break Cursor --------------------------
153: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
154: select aei_information1 p_immigration_purpose,
155: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,
156: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,
157: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,
158: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date
159: from per_assignment_extra_info

Line 156: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,

152: ------------------------- FW Tax Break Cursor --------------------------
153: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
154: select aei_information1 p_immigration_purpose,
155: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,
156: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,
157: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,
158: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date
159: from per_assignment_extra_info
160: where assignment_id = p_assignment_id

Line 157: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,

153: cursor csr_fw_tax_break(p_assignment_id number, p_year number) is
154: select aei_information1 p_immigration_purpose,
155: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,
156: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,
157: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,
158: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date
159: from per_assignment_extra_info
160: where assignment_id = p_assignment_id
161: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'

Line 158: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date

154: select aei_information1 p_immigration_purpose,
155: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_fw_contract_date,
156: to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_fw_expiry_date,
157: to_char(fnd_date.canonical_to_date(aei_information5) , 'YYYY.MM.DD') p_fw_application_date,
158: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date
159: from per_assignment_extra_info
160: where assignment_id = p_assignment_id
161: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
162: and p_year between to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY')

Line 162: and p_year between to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY')

158: to_char(fnd_date.canonical_to_date(aei_information6) , 'YYYY.MM.DD') p_fw_submit_date
159: from per_assignment_extra_info
160: where assignment_id = p_assignment_id
161: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
162: and p_year between to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY')
163: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');
164:
165: ---------------------------SMB Tax Reductions-------------------------------
166: cursor csr_smb_tax_red(p_assignment_id number, p_year number) is

Line 163: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');

159: from per_assignment_extra_info
160: where assignment_id = p_assignment_id
161: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
162: and p_year between to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY')
163: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');
164:
165: ---------------------------SMB Tax Reductions-------------------------------
166: cursor csr_smb_tax_red(p_assignment_id number, p_year number) is
167: select to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_smb_start_date,

Line 167: select to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_smb_start_date,

163: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');
164:
165: ---------------------------SMB Tax Reductions-------------------------------
166: cursor csr_smb_tax_red(p_assignment_id number, p_year number) is
167: select to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_smb_start_date,
168: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_smb_end_date
169: from per_assignment_extra_info
170: where assignment_id = p_assignment_id
171: and information_type = 'KR_YEA_TAX_REDUCTION_SMB'

Line 168: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_smb_end_date

164:
165: ---------------------------SMB Tax Reductions-------------------------------
166: cursor csr_smb_tax_red(p_assignment_id number, p_year number) is
167: select to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_smb_start_date,
168: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_smb_end_date
169: from per_assignment_extra_info
170: where assignment_id = p_assignment_id
171: and information_type = 'KR_YEA_TAX_REDUCTION_SMB'
172: and p_year between to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')

Line 172: and p_year between to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')

168: to_char(fnd_date.canonical_to_date(aei_information2) , 'YYYY.MM.DD') p_smb_end_date
169: from per_assignment_extra_info
170: where assignment_id = p_assignment_id
171: and information_type = 'KR_YEA_TAX_REDUCTION_SMB'
172: and p_year between to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')
173: and to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY');
174:
175: ---------------------------Teachers Treaty Reductions-------------------------------
176: cursor csr_teach_tax_red(p_assignment_id number, p_year number) is

Line 173: and to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY');

169: from per_assignment_extra_info
170: where assignment_id = p_assignment_id
171: and information_type = 'KR_YEA_TAX_REDUCTION_SMB'
172: and p_year between to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')
173: and to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY');
174:
175: ---------------------------Teachers Treaty Reductions-------------------------------
176: cursor csr_teach_tax_red(p_assignment_id number, p_year number) is
177: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_teach_application_date,

Line 177: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_teach_application_date,

173: and to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY');
174:
175: ---------------------------Teachers Treaty Reductions-------------------------------
176: cursor csr_teach_tax_red(p_assignment_id number, p_year number) is
177: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_teach_application_date,
178: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_teach_submit_date
179: from per_assignment_extra_info
180: where assignment_id = p_assignment_id
181: and information_type = 'KR_YEA_TAX_REDUCTION_TEACHERS'

Line 178: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_teach_submit_date

174:
175: ---------------------------Teachers Treaty Reductions-------------------------------
176: cursor csr_teach_tax_red(p_assignment_id number, p_year number) is
177: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_teach_application_date,
178: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_teach_submit_date
179: from per_assignment_extra_info
180: where assignment_id = p_assignment_id
181: and information_type = 'KR_YEA_TAX_REDUCTION_TEACHERS'
182: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')

Line 182: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')

178: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_teach_submit_date
179: from per_assignment_extra_info
180: where assignment_id = p_assignment_id
181: and information_type = 'KR_YEA_TAX_REDUCTION_TEACHERS'
182: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')
183: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');
184:
185: ---------------------------Marine Tax Reductions-------------------------------
186: cursor csr_marine_tax_red(p_assignment_id number, p_year number) is

Line 183: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');

179: from per_assignment_extra_info
180: where assignment_id = p_assignment_id
181: and information_type = 'KR_YEA_TAX_REDUCTION_TEACHERS'
182: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')
183: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');
184:
185: ---------------------------Marine Tax Reductions-------------------------------
186: cursor csr_marine_tax_red(p_assignment_id number, p_year number) is
187: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_marine_confirm_date,

Line 187: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_marine_confirm_date,

183: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');
184:
185: ---------------------------Marine Tax Reductions-------------------------------
186: cursor csr_marine_tax_red(p_assignment_id number, p_year number) is
187: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_marine_confirm_date,
188: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_marine_submit_date
189: from per_assignment_extra_info
190: where assignment_id = p_assignment_id
191: and information_type = 'KR_YEA_TAX_REDUCTION_MARINE'

Line 188: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_marine_submit_date

184:
185: ---------------------------Marine Tax Reductions-------------------------------
186: cursor csr_marine_tax_red(p_assignment_id number, p_year number) is
187: select to_char(fnd_date.canonical_to_date(aei_information3) , 'YYYY.MM.DD') p_marine_confirm_date,
188: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_marine_submit_date
189: from per_assignment_extra_info
190: where assignment_id = p_assignment_id
191: and information_type = 'KR_YEA_TAX_REDUCTION_MARINE'
192: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')

Line 192: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')

188: to_char(fnd_date.canonical_to_date(aei_information4) , 'YYYY.MM.DD') p_marine_submit_date
189: from per_assignment_extra_info
190: where assignment_id = p_assignment_id
191: and information_type = 'KR_YEA_TAX_REDUCTION_MARINE'
192: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')
193: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');
194:
195: ------------------------Traditional Market-------------------
196: cursor per_asg_extra_info_tm_csr(p_assignment_id number, p_year number) is

Line 193: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');

189: from per_assignment_extra_info
190: where assignment_id = p_assignment_id
191: and information_type = 'KR_YEA_TAX_REDUCTION_MARINE'
192: and p_year between to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY')
193: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');
194:
195: ------------------------Traditional Market-------------------
196: cursor per_asg_extra_info_tm_csr(p_assignment_id number, p_year number) is
197: select aei_information3 tm_emp_crd_exp

Line 222: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

218: sum(nvl(aei_information18,0)) p_total_ltci_prem /* Bug 7644535 */
219: from per_assignment_extra_info
220: where assignment_id = p_assignment_id
221: and information_type = 'KR_YEA_PREV_ER_INFO'
222: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
223:
224: ------------------------- Dependent Expense Information ------------------
225: -- Bug 5726158
226: cursor csr_dpnt_expense_info(p_assignment_id number, p_effective_date date) is

Line 292: decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -

288: ---------------------------------------------------------------------------------
289: cursor csr_get_join_leave_info (p_assignment_id number, p_effective_date date) is
290: Select decode(sign(to_number(to_char(pds.date_start,'YYYY')) -
291: (to_number(to_char(p_effective_date,'YYYY'))-1)),1,'X',0,'Y','N') Joined_last_year,
292: decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -
293: to_number(to_char(p_effective_date,'YYYY'))),1,'N',0,'Y','X') Leaving_cur_year,
294: asg.business_group_id bus_grp_id
295: from per_periods_of_service pds,
296: per_assignments_f asg

Line 340: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

336: select sum(nvl(to_number(aei_information6), 0))
337: from per_assignment_extra_info
338: where assignment_id = p_assignment_id
339: and information_type = 'KR_YEA_HOU_RENT_DETAILS'
340: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
341: ------------------------------------------------------------------------------------
342: cursor csr_housing_rent_details(p_assignment_id number, p_year number) is
343: select
344: aei_information2 type,

Line 349: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;

345: to_number(aei_information5) cont_amount
346: from per_assignment_extra_info
347: where assignment_id = p_assignment_id
348: and information_type = 'KR_YEA_HOU_SAVING_DETAILS'
349: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY')= p_year;
350: ------------------------------------------------------------------------------------
351: cursor csr_sep_pen_details(p_assignment_id number, p_year number) is
352: select rownum,
353: aei_information6 priority,

Line 361: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year

357: to_number(aei_information5) cont_amount
358: from per_assignment_extra_info
359: where assignment_id = p_assignment_id
360: and information_type = 'KR_YEA_SEP_PEN_DETAILS'
361: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year
362: order by to_number(aei_information6);
363: -----------------------------------------------------------------------------------
364: cursor csr_pen_sav_details(p_assignment_id number, p_year number)is
365: select

Line 375: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year

371: to_number(aei_information5) cont_amount
372: from per_assignment_extra_info
373: where assignment_id = p_assignment_id
374: and information_type = 'KR_YEA_PEN_SAVING_DETAILS'
375: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year
376: order by to_number(aei_information6);
377: -----------------------------------------------------------------------------------
378: cursor csr_hou_sav_details(p_assignment_id number, p_year number) is
379: select

Line 389: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year

385: to_number(aei_information5) cont_amount
386: from per_assignment_extra_info
387: where assignment_id = p_assignment_id
388: and information_type = 'KR_YEA_HOU_SAVING_DETAILS'
389: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year
390: order by to_number(aei_information6);
391: -----------------------------------------------------------------------------------
392: cursor csr_lt_stck_sav_details(p_assignment_id number, p_year number) is
393: select

Line 403: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year

399: to_number(aei_information5) cont_amount
400: from per_assignment_extra_info
401: where assignment_id = p_assignment_id
402: and information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'
403: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year
404: order by to_number(aei_information6);
405: ------------------------------------------------------------------------------------
406: cursor csr_wkpd (p_assignment_id number,p_year number) is
407: select

Line 1416: ,nvl(aei_information1,fnd_date.date_to_canonical(to_date('31-12-'||to_char(p_year),'dd-mm-rrrr'))) --Effective Date

1412: + nvl(aei_information22,0)
1413: + nvl(aei_information23,0)
1414: + nvl(aei_information30,0)) --Donation Total1
1415: ,nvl(aei_information19,0) --Political_donation
1416: ,nvl(aei_information1,fnd_date.date_to_canonical(to_date('31-12-'||to_char(p_year),'dd-mm-rrrr'))) --Effective Date
1417: from per_assignment_extra_info
1418: where ASSIGNMENT_ID=p_emp_assignment_id
1419: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
1420: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

Line 1420: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

1416: ,nvl(aei_information1,fnd_date.date_to_canonical(to_date('31-12-'||to_char(p_year),'dd-mm-rrrr'))) --Effective Date
1417: from per_assignment_extra_info
1418: where ASSIGNMENT_ID=p_emp_assignment_id
1419: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
1420: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
1421:
1422: cursor sp_tax_exem_info2 is
1423: select nvl(aei_information2,0) --Education Exem Total2
1424: ,(nvl(aei_information4,0)

Line 1434: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

1430: ,nvl(aei_information10,'N') -- Bug 9381801: Medical Total and Details Flag
1431: from per_assignment_extra_info
1432: where ASSIGNMENT_ID=p_emp_assignment_id
1433: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
1434: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
1435:
1436: cursor tax_exem_info is
1437: select nvl(aei_information7,0) --Card Total
1438: ,nvl(aei_information13,0) --Cash Total

Line 1444: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

1440: , nvl(aei_information12,0) -- Tution Total
1441: from per_assignment_extra_info
1442: where ASSIGNMENT_ID=p_emp_assignment_id
1443: and information_type = 'KR_YEA_TAX_EXEM_INFO'
1444: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
1445:
1446: cursor tax_exem_info2 is
1447: select nvl(aei_information3, 0), -- TM Card Total Bug 15911822
1448: nvl(aei_information5, 0), -- TM Cash Total Bug 15911822

Line 1453: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

1449: nvl(aei_information7, 0) -- TM Direct Total Bug 15911822
1450: from per_assignment_extra_info
1451: where ASSIGNMENT_ID=p_emp_assignment_id
1452: and information_type = 'KR_YEA_TAX_EXEM_INFO2'
1453: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
1454:
1455: cursor csr_get_ins_bal(p_balance_name in varchar2,
1456: p_dimension_name in varchar2) is
1457: select defined_balance_id

Line 1479: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

1475: ,aei_information9 -- TM Direct NTS Bug 15911822
1476: from per_assignment_extra_info
1477: where ASSIGNMENT_ID=p_emp_assignment_id
1478: and information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
1479: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
1480:
1481: -- Bug 9381801
1482: cursor medical_emp_totals is
1483: select

Line 1488: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;

1484: nvl(sum(decode(aei_information7, '0', nvl(aei_information3,0) + nvl(aei_information11,0), 0)),0) employee
1485: from per_assignment_extra_info pai
1486: where pai.assignment_id = p_emp_assignment_id
1487: and pai.information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
1488: and to_char(fnd_date.canonical_to_date(aei_information1), 'YYYY') = p_year;
1489:
1490:
1491: -- Local Variables
1492: