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 PER_ASSIGNMENT_EXTRA_INFO

Line 11: from per_assignment_extra_info

7: ------------------------- Education Exp Cursor----------------------------
8: cursor per_asg_extra_info_educ_csr(p_assignment_id number, p_year number) is
9: select aei_information3
10: ,to_number(aei_information4)
11: from per_assignment_extra_info
12: where assignment_id = p_assignment_id
13: and information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO'
14: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
15: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 22: from per_assignment_extra_info

18: -- Bug 9341235
19: cursor per_asg_extra_info_educ_2009(p_assignment_id number, p_year number) is
20: select aei_information3
21: ,sum(to_number(aei_information4))
22: from per_assignment_extra_info
23: where assignment_id = p_assignment_id and
24: information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO'
25: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
26: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr')

Line 54: from per_assignment_extra_info

50: ,aei_information27 l_marriage_count
51: ,aei_information29 l_reloc_count
52: ,aei_information28 l_funeral_count
53: ,aei_information26 l_lt_hou_int_repay_gt_15
54: from per_assignment_extra_info
55: where assignment_id = p_assignment_id
56: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
57: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
58: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 71: from per_assignment_extra_info

67: aei_information6 l_other_don,
68: aei_information7 l_public_legal_don, -- Bug 7508706
69: aei_information11 ltci_prem, -- Bug 7644535
70: aei_information13 l_lt_1500_won_limit -- Bug 9079478
71: from per_assignment_extra_info
72: where assignment_id = p_assignment_id
73: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
74: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
75: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 84: from per_assignment_extra_info

80: cursor per_asg_extra_info_sp3_csr(p_assignment_id number, p_year number) is
81: select aei_information4,
82: aei_information6,
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 -----------------------

Line 111: from per_assignment_extra_info

107: ,aei_information23 long_term_stck_fund_2yr -- Bug 7615517
108: ,aei_information24 long_term_stck_fund_3yr -- Bug 7615517
109: ,nvl(to_number(aei_information26),0) -- Bug 9079478
110: ,nvl(to_number(aei_information27),0) -- Bug 9079478
111: from per_assignment_extra_info
112: where assignment_id = p_assignment_id
113: and information_type = 'KR_YEA_TAX_EXEM_INFO'
114: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
115: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 122: from per_assignment_extra_info

118: cursor per_asg_extra_info_break_csr(p_assignment_id number, p_year number) is
119: select aei_information2 hou_loan_int_repay
120: ,aei_information4 lt_stk_sav1
121: ,aei_information5 lt_stk_sav2
122: from per_assignment_extra_info
123: where assignment_id = p_assignment_id
124: and information_type = 'KR_YEA_TAX_BREAK_INFO'
125: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
126: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 131: from per_assignment_extra_info

127:
128: ------------------------- FW Info Cursor -------------------------------
129: cursor per_asg_extra_info_fw_csr(p_assignment_id number, p_year number) is
130: select nvl(aei_information2,0) + nvl(aei_information3,0)
131: from per_assignment_extra_info
132: where assignment_id = p_assignment_id
133: and information_type = 'KR_YEA_FW_TAX_EXEM_INFO'
134: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
135: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 147: from per_assignment_extra_info

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
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:

Line 159: from per_assignment_extra_info

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')
163: and to_char(fnd_date.canonical_to_date(aei_information3), 'YYYY');

Line 169: from per_assignment_extra_info

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')
173: and to_char(fnd_date.canonical_to_date(aei_information2), 'YYYY');

Line 179: from per_assignment_extra_info

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')
183: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');

Line 189: from per_assignment_extra_info

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')
193: and to_char(fnd_date.canonical_to_date(aei_information4), 'YYYY');

Line 206: from per_assignment_extra_info

202: ,aei_information8 tm_dep_dir_exp
203: ,aei_information10 inv_fin_2011
204: ,aei_information11 inv_fin_2012_ordinary
205: ,aei_information12 inv_fin_2012_venture
206: from per_assignment_extra_info
207: where ASSIGNMENT_ID = p_assignment_id
208: and information_type = 'KR_YEA_TAX_EXEM_INFO2'
209: and to_date(aei_information1,'rrrr/mm/dd hh24:mi:ss')
210: = to_date('31-12-'||to_char(p_year),'dd-mm-rrrr');

Line 219: from per_assignment_extra_info

215: sum(nvl(aei_information12,0)) p_total_np_prem,
216: sum(nvl(aei_information16,0)) p_total_pen_prem, /* Bug 6655323 */
217: sum(nvl(aei_information19,0)) p_total_sep_pension, /* Bug 7508706 */
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:

Line 331: From per_assignment_extra_info

327: ------------------------------------------------------------------------------------
328: Cursor csr_fixed_tax_rate(p_assignment_id number)
329: IS
330: Select aei_information1
331: From per_assignment_extra_info
332: Where assignment_id = p_assignment_id
333: And information_type = 'KR_YEA_FOREIGN_WORKER_TAX';
334: ------------------------------------------------------------------------------------
335: cursor csr_hou_rent(p_assignment_id number, p_year number) is

Line 337: from per_assignment_extra_info

333: And information_type = 'KR_YEA_FOREIGN_WORKER_TAX';
334: ------------------------------------------------------------------------------------
335: cursor csr_hou_rent(p_assignment_id number, p_year number) is
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: ------------------------------------------------------------------------------------

Line 346: from per_assignment_extra_info

342: cursor csr_housing_rent_details(p_assignment_id number, p_year number) is
343: select
344: aei_information2 type,
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: ------------------------------------------------------------------------------------

Line 358: from per_assignment_extra_info

354: aei_information2 type,
355: aei_information3 fin_institute,
356: aei_information4 acc_number,
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);

Line 372: from per_assignment_extra_info

368: aei_information2 type,
369: aei_information3 fin_institute,
370: aei_information4 acc_number,
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);

Line 386: from per_assignment_extra_info

382: aei_information2 type,
383: aei_information3 fin_institute,
384: aei_information4 acc_number,
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);

Line 400: from per_assignment_extra_info

396: aei_information2 type,
397: aei_information3 fin_institute,
398: aei_information4 acc_number,
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);

Line 1417: from per_assignment_extra_info

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;
1421:

Line 1431: from per_assignment_extra_info

1427: +nvl(aei_information7,0)) -- Bug 7508706: Donation Total2
1428: ,nvl(aei_information8,0) -- Bug 7508706: Total Dependent Donation Expense
1429: ,nvl(aei_information11, 0) -- Bug 7644535: LTCI premium
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:

Line 1441: from per_assignment_extra_info

1437: select nvl(aei_information7,0) --Card Total
1438: ,nvl(aei_information13,0) --Cash Total
1439: ,nvl(aei_information10,0) --Direct Total
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:

Line 1450: from per_assignment_extra_info

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
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:

Line 1476: from per_assignment_extra_info

1472: ,aei_information6 --Insurance NTS -- Bug 5726158
1473: ,aei_information7 --Direct Payment -- Bug 10184055
1474: ,aei_information8 -- TM Card NTS Bug 15911822
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:

Line 1485: from per_assignment_extra_info pai

1481: -- Bug 9381801
1482: cursor medical_emp_totals is
1483: select
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: