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_PAYKRYTR_PKG dependencies on FND_DATE

Line 159: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')

155: where paa.assignment_action_id = p_assignment_action_id
156: and ppa.payroll_action_id = paa.payroll_action_id
157: and pi.assignment_id = paa.assignment_id
158: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
159: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
160: = trunc(ppa.effective_date, 'YYYY');
161:
162: --5190884
163: cursor csr_emp_exp_details is

Line 176: and trunc(fnd_date.canonical_to_date(pei.aei_information1), 'YYYY')

172: where paa.assignment_action_id = p_assignment_action_id
173: and ppa.payroll_action_id = paa.payroll_action_id
174: and pei.assignment_id = paa.assignment_id
175: and pei.information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
176: and trunc(fnd_date.canonical_to_date(pei.aei_information1), 'YYYY')
177: = trunc(ppa.effective_date, 'YYYY');
178:
179: cursor csr_get_emp_exp_amount is
180: select nvl(to_number(aei_information18), 0) + nvl(to_number(aei_information19), 0) +

Line 190: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')

186: where paa.assignment_action_id = p_assignment_action_id
187: and ppa.payroll_action_id = paa.payroll_action_id
188: and pi.assignment_id = paa.assignment_id
189: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
190: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
191: = trunc(ppa.effective_date, 'YYYY');
192:
193: cursor csr_get_emp_card_expense is
194: select nvl(to_number(aei_information7), 0) + nvl(to_number(aei_information10), 0)

Line 203: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')

199: where paa.assignment_action_id = p_assignment_action_id
200: and ppa.payroll_action_id = paa.payroll_action_id
201: and pi.assignment_id = paa.assignment_id
202: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
203: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
204: = trunc(ppa.effective_date, 'YYYY');
205:
206: cursor csr_get_emp_don_educ_details is
207: select nvl(to_number(aei_information4), 0) +

Line 218: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')

214: where paa.assignment_action_id = p_assignment_action_id
215: and ppa.payroll_action_id = paa.payroll_action_id
216: and pi.assignment_id = paa.assignment_id
217: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
218: and trunc(fnd_date.canonical_to_date(pi.aei_information1), 'YYYY')
219: = trunc(ppa.effective_date, 'YYYY');
220:
221: -- Bug 5726158
222: cursor csr_asg_details is

Line 505: l_don_tax_break2004 := pay_kr_yea_form_pkg.get_donation_tax_break(fnd_date.date_to_canonical(l_rec.effective_date), l_yea_info.political_donation1);

501: + l_yea_info.disabled_ins_prem); -- Bug 7260606
502: p_emp_med_exp_oth := l_yea_info.med_exp_emp - p_emp_med_exp_nts;
503: -- Bug : 5745179
504: --
505: l_don_tax_break2004 := pay_kr_yea_form_pkg.get_donation_tax_break(fnd_date.date_to_canonical(l_rec.effective_date), l_yea_info.political_donation1);
506: --
507: p_emp_don_exp_oth := ( l_don_amount1 + l_don_amount2 - nvl(l_don_tax_break2004,0)) - p_emp_don_exp_nts;
508: p_emp_educ_exp_oth := ( l_yea_info.ee_educ_exp + l_emp_occu_trng ) - p_emp_educ_exp_nts;
509: p_emp_card_exp_oth := l_card_expense_total - p_emp_card_exp_nts;