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_YEA_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1692: from per_assignment_extra_info

1688: nvl(to_number(aei_information20), 0), -- Bug 8644512
1689: nvl(to_number(aei_information21), 0), -- Bug 8644512
1690: nvl(to_number(aei_information22), 0), -- Bug 8644512
1691: nvl(to_number(aei_information23), 0) -- Bug 8644512
1692: from per_assignment_extra_info
1693: where assignment_id = p_assignment_id
1694: and information_type = 'KR_YEA_TAX_GROUP_INFO'
1695: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1696: l_dummy number;

Line 1926: from per_assignment_extra_info

1922: nvl(to_number(aei_information21), 0) aei21, -- Bug 8341054
1923: nvl(to_number(aei_information22), 0) aei22, -- Bug 8341054
1924: nvl(to_number(aei_information26), 0) aei26, -- Bug 8644512
1925: assignment_extra_info_id asg_ex_info_id -- Bug 9737699
1926: from per_assignment_extra_info
1927: where assignment_id = p_assignment_id
1928: and information_type = 'KR_YEA_PREV_ER_INFO'
1929: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
1930: order by 1;

Line 1935: from per_assignment_extra_info

1931: cursor csr_aei2(p_assignment_extra_info_id in number)is
1932: select nvl(to_number(aei_information4), 0) aei4,
1933: nvl(to_number(aei_information5), 0) aei5,
1934: nvl(to_number(aei_information6), 0) aei6
1935: from per_assignment_extra_info
1936: where assignment_id = p_assignment_id
1937: and information_type = 'KR_YEA_PREV_ER_INFO2'
1938: and aei_information2 = p_assignment_extra_info_id
1939: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2119: from per_assignment_extra_info

2115: aei_information2 type,
2116: aei_information3 fin_institute,
2117: aei_information4 acc_number,
2118: to_number(aei_information5) cont_amount
2119: from per_assignment_extra_info
2120: where assignment_id = p_assignment_id
2121: and information_type = 'KR_YEA_SEP_PEN_DETAILS'
2122: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2123: order by to_number(aei_information6);

Line 2154: from per_assignment_extra_info

2150: aei_information2 type,
2151: aei_information3 fin_institute,
2152: aei_information4 acc_number,
2153: to_number(aei_information5) cont_amount
2154: from per_assignment_extra_info
2155: where assignment_id = p_assignment_id
2156: and information_type = 'KR_YEA_PEN_SAVING_DETAILS'
2157: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2158: order by to_number(aei_information6);

Line 2187: from per_assignment_extra_info

2183: aei_information2 type,
2184: aei_information3 fin_institute,
2185: aei_information4 acc_number,
2186: to_number(aei_information5) cont_amount
2187: from per_assignment_extra_info
2188: where assignment_id = p_assignment_id
2189: and information_type = 'KR_YEA_HOU_SAVING_DETAILS'
2190: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2191: order by to_number(aei_information6);

Line 2220: from per_assignment_extra_info

2216: aei_information2 type,
2217: aei_information3 fin_institute,
2218: aei_information4 acc_number,
2219: to_number(aei_information5) cont_amount
2220: from per_assignment_extra_info
2221: where assignment_id = p_assignment_id
2222: and information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'
2223: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2224: order by to_number(aei_information6);

Line 2250: from per_assignment_extra_info

2246: cursor csr_ntax_details is
2247: select aei_information4 bus_reg_num,
2248: aei_information2 code,
2249: nvl(aei_information5,0) value
2250: from per_assignment_extra_info
2251: where assignment_id = p_assignment_id
2252: and information_type = 'KR_YEA_NON_TAXABLE_EARN_DETAIL'
2253: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2254: order by 1;

Line 2288: from per_assignment_extra_info

2284: select
2285: assignment_extra_info_id asg_info_id,
2286: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2287: nvl(to_number(aei_information2),0) donated_year
2288: from per_assignment_extra_info
2289: where assignment_id = p_assignment_id
2290: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2291: and aei_information8 = '31'
2292: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2300: from per_assignment_extra_info

2296: select
2297: assignment_extra_info_id asg_info_id,
2298: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2299: nvl(to_number(aei_information2),0) donated_year
2300: from per_assignment_extra_info
2301: where assignment_id = p_assignment_id
2302: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2303: and aei_information8 = '31'
2304: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2312: from per_assignment_extra_info

2308: cursor csr_pledt_don_current is
2309: select assignment_extra_info_id asg_info_id,
2310: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2311: to_number(aei_information2) donated_year
2312: from per_assignment_extra_info
2313: where assignment_id = p_assignment_id
2314: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2315: and aei_information8 = '31'
2316: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2324: from per_assignment_extra_info

2320: cursor csr_pledt_don_carry_over is
2321: select assignment_extra_info_id asg_info_id,
2322: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2323: to_number(aei_information2) donated_year
2324: from per_assignment_extra_info
2325: where assignment_id = p_assignment_id
2326: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2327: and aei_information8 = '31'
2328: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2395: from per_assignment_extra_info

2391: select
2392: assignment_extra_info_id asg_info_id,
2393: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2394: nvl(to_number(aei_information2),0) donated_year
2395: from per_assignment_extra_info
2396: where assignment_id = p_assignment_id
2397: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2398: and aei_information8 = '30'
2399: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2407: from per_assignment_extra_info

2403: select
2404: assignment_extra_info_id asg_info_id,
2405: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2406: nvl(to_number(aei_information2),0) donated_year
2407: from per_assignment_extra_info
2408: where assignment_id = p_assignment_id
2409: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2410: and aei_information8 = '30'
2411: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2419: from per_assignment_extra_info

2415: cursor csr_tlaw_don_current is
2416: select assignment_extra_info_id asg_info_id,
2417: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2418: to_number(aei_information2) donated_year
2419: from per_assignment_extra_info
2420: where assignment_id = p_assignment_id
2421: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2422: and aei_information8 = '30'
2423: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2431: from per_assignment_extra_info

2427: cursor csr_tlaw_don_carry_over is
2428: select assignment_extra_info_id asg_info_id,
2429: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2430: to_number(aei_information2) donated_year
2431: from per_assignment_extra_info
2432: where assignment_id = p_assignment_id
2433: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2434: and aei_information8 = '30'
2435: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2502: from per_assignment_extra_info

2498: select
2499: assignment_extra_info_id asg_info_id,
2500: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2501: nvl(to_number(aei_information2),0) donated_year
2502: from per_assignment_extra_info
2503: where assignment_id = p_assignment_id
2504: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2505: and aei_information8 = '10'
2506: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2514: from per_assignment_extra_info

2510: select
2511: assignment_extra_info_id asg_info_id,
2512: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2513: nvl(to_number(aei_information2),0) donated_year
2514: from per_assignment_extra_info
2515: where assignment_id = p_assignment_id
2516: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2517: and aei_information8 = '10'
2518: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2525: from per_assignment_extra_info

2521: cursor csr_stat_don_current is
2522: select assignment_extra_info_id asg_info_id,
2523: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2524: to_number(aei_information2) donated_year
2525: from per_assignment_extra_info
2526: where assignment_id = p_assignment_id
2527: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2528: and aei_information8 = '10'
2529: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2537: from per_assignment_extra_info

2533: cursor csr_stat_don_carry_over is
2534: select assignment_extra_info_id asg_info_id,
2535: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2536: to_number(aei_information2) donated_year
2537: from per_assignment_extra_info
2538: where assignment_id = p_assignment_id
2539: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2540: and aei_information8 = '10'
2541: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2607: from per_assignment_extra_info

2603: select
2604: assignment_extra_info_id asg_info_id,
2605: to_number(aei_information2) donated_year,
2606: nvl(to_number(aei_information10),0) amt_sub_to_exem
2607: from per_assignment_extra_info
2608: where assignment_id = p_assignment_id
2609: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2610: and aei_information8 = '40'
2611: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2647: from per_assignment_extra_info

2643: select
2644: assignment_extra_info_id asg_info_id,
2645: to_number(aei_information2) donated_year,
2646: nvl(to_number(aei_information10),0) amt_sub_to_exem
2647: from per_assignment_extra_info
2648: where assignment_id = p_assignment_id
2649: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2650: and aei_information8 = '41'
2651: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2736: from per_assignment_extra_info

2732: select
2733: sum(decode(chk_valid_donation(to_number(aei_information10),aei_information8,p_effective_date),'Y',nvl(to_number(aei_information10),0),0)),
2734: to_number(aei_information2)
2735:
2736: from per_assignment_extra_info
2737: where assignment_id = p_assignment_id
2738: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2739: and aei_information8 in ('40','41')
2740: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2749: from per_assignment_extra_info

2745: select
2746: sum(decode(chk_valid_donation(to_number(aei_information10),aei_information8,p_effective_date),'Y',nvl(to_number(aei_information10),0),0)),
2747: to_number(aei_information2)
2748:
2749: from per_assignment_extra_info
2750: where assignment_id = p_assignment_id
2751: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2752: and aei_information8 = ('41')
2753: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2829: from per_assignment_extra_info

2825: assignment_extra_info_id asg_info_id,
2826: to_number(aei_information2) donated_year,
2827: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2828: aei_information8 donation_code
2829: from per_assignment_extra_info
2830: where assignment_id = p_assignment_id
2831: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2832: and aei_information8 in ('41','40')
2833: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2842: from per_assignment_extra_info

2838: assignment_extra_info_id asg_info_id,
2839: to_number(aei_information2) donated_year,
2840: nvl(to_number(aei_information10),0) amt_sub_to_exem,
2841: aei_information8 donation_code
2842: from per_assignment_extra_info
2843: where assignment_id = p_assignment_id
2844: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2845: and aei_information8 in ('41','40')
2846: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2853: from per_assignment_extra_info

2849: -- to select current and carryover years..
2850: cursor csr_spec_rel_year is
2851: select donated_year from (
2852: select distinct aei_information2 donated_year
2853: from per_assignment_extra_info
2854: where assignment_id = p_assignment_id
2855: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2856: and aei_information8 in ('41','40')
2857: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2865: from per_assignment_extra_info

2861: select assignment_extra_info_id asg_info_id,
2862: aei_information8 donation_code,
2863: to_number(aei_information2) donated_year,
2864: nvl(to_number(aei_information10),0) amt_sub_to_exem
2865: from per_assignment_extra_info
2866: where assignment_id = p_assignment_id
2867: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2868: and aei_information8 in ('41','40')
2869: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 2878: from per_assignment_extra_info

2874: select assignment_extra_info_id asg_info_id,
2875: aei_information8 donation_code,
2876: to_number(aei_information2) donated_year,
2877: nvl(to_number(aei_information10),0) amt_sub_to_exem
2878: from per_assignment_extra_info
2879: where assignment_id = p_assignment_id
2880: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2881: and aei_information8 in ('41','40')
2882: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 3042: from per_assignment_extra_info

3038: aei_information28,
3039: aei_information29,
3040: -- Bug 3172960
3041: nvl(to_number(aei_information24), 0)
3042: from per_assignment_extra_info
3043: where assignment_id = p_assignment_id
3044: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
3045: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3046:

Line 3057: from per_assignment_extra_info

3053: ,nvl(to_number(aei_information11), 0) -- Bug 7260606
3054: ,nvl(to_number(aei_information7), 0) -- Bug 7142612: Public Legal Entity Donation Trust
3055: ,fnd_date.canonical_to_date(aei_information12) -- Bug 8237227
3056: ,nvl(to_number(aei_information13), 0) -- Bug 8237227
3057: from per_assignment_extra_info
3058: where assignment_id = p_assignment_id
3059: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
3060: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3061:

Line 3070: from per_assignment_extra_info

3066: nvl(to_number(aei_information4), 0),
3067: aei_information5, -- Bug 13247926
3068: nvl(to_number(aei_information6),0), -- Bug 14754836
3069: nvl(to_number(aei_information7),0) -- Bug 14754836
3070: from per_assignment_extra_info
3071: where assignment_id = p_assignment_id
3072: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO3'
3073: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3074: --

Line 3130: from per_assignment_extra_info

3126: ),0
3127: ) -- Aged Total
3128: ,nvl(sum(decode(aei_information9,'A',0,'B',0,
3129: decode(aei_information7,0,0,(nvl(aei_information3,0) + nvl(aei_information11,0))))),0) -- Dependent Total
3130: from per_assignment_extra_info
3131: where assignment_id = p_assignment_id
3132: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
3133: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3134:

Line 3148: from per_assignment_extra_info

3144: --
3145: -- Bug 9393732
3146: cursor csr_hou_rent is
3147: select sum(nvl(to_number(aei_information6), 0))
3148: from per_assignment_extra_info
3149: where assignment_id = p_assignment_id
3150: and information_type = 'KR_YEA_HOU_RENT_DETAILS'
3151: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3152:

Line 3296: from per_assignment_extra_info

3292: aei_information3,
3293: sum(nvl(to_number(aei_information4), 0)), -- Bug 9348911
3294: aei_information7, -- Bug 9079450: Contact Name
3295: aei_information5 -- Bug 9079450: Contact National Identifier
3296: from per_assignment_extra_info
3297: where assignment_id = p_assignment_id
3298: and information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO'
3299: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
3300: group by aei_information5,aei_information7,aei_information3,aei_information2; -- Bug 9348911

Line 3324: from per_assignment_extra_info

3320: is
3321: cursor csr_aei is
3322: select nvl(to_number(aei_information2), 0),
3323: nvl(to_number(aei_information3), 0)
3324: from per_assignment_extra_info
3325: where assignment_id = p_assignment_id
3326: and information_type = 'KR_YEA_FW_TAX_EXEM_INFO'
3327: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3328: begin

Line 3348: from per_assignment_extra_info

3344: is
3345: cursor csr_aei is
3346: select aei_information2,
3347: nvl(to_number(aei_information3), 0)
3348: from per_assignment_extra_info
3349: where assignment_id = p_assignment_id
3350: and information_type = 'KR_YEA_HOU_EXP_TAX_EXEM_INFO'
3351: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3352: begin

Line 3471: from per_assignment_extra_info

3467: nvl(to_number(aei_information23), 0), -- Bug 7615517: Long Term Stock Fund for 2nd Year
3468: nvl(to_number(aei_information24), 0), -- Bug 7615517: Long Term Stock Fund for 3rd Year
3469: nvl(to_number(aei_information26), 0), -- Bug 9079450: Working Days for the Current Period
3470: nvl(to_number(aei_information27), 0) -- Bug 9079450: Working Days for the Previous Period
3471: from per_assignment_extra_info
3472: where assignment_id = p_assignment_id
3473: and information_type = 'KR_YEA_TAX_EXEM_INFO'
3474: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3475:

Line 3488: from per_assignment_extra_info

3484: nvl(to_number(aei_information9), 0), -- giro tuition paid
3485: nvl(to_number(aei_information10), 0), -- Invest_Partner_Fin_2011
3486: nvl(to_number(aei_information11), 0), -- Invest_Partner_Fin_2012_Ordinary
3487: nvl(to_number(aei_information12), 0) -- Invest_Partner_Fin_2012_Venture
3488: from per_assignment_extra_info
3489: where assignment_id = p_assignment_id
3490: and information_type = 'KR_YEA_TAX_EXEM_INFO2'
3491: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3492: -- Bug 14219478 End

Line 3676: from per_assignment_extra_info

3672: select nvl(to_number(aei_information2), 0),
3673: nvl(to_number(aei_information3), 0),
3674: nvl(to_number(aei_information4), 0),
3675: nvl(to_number(aei_information5), 0)
3676: from per_assignment_extra_info
3677: where assignment_id = p_assignment_id
3678: and information_type = 'KR_YEA_TAX_BREAK_INFO'
3679: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3680: begin

Line 3716: from per_assignment_extra_info

3712: nvl(to_number(aei_information7), 0),
3713: nvl(to_number(aei_information8), 0),
3714: fnd_date.canonical_to_date(aei_information9),
3715: fnd_date.canonical_to_date(aei_information10)
3716: from per_assignment_extra_info
3717: where assignment_id = p_assignment_id
3718: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'
3719: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3720: begin

Line 3759: from per_assignment_extra_info

3755: fnd_date.canonical_to_date(aei_information2),
3756: fnd_date.canonical_to_date(aei_information3),
3757: fnd_date.canonical_to_date(aei_information5),
3758: fnd_date.canonical_to_date(aei_information6)
3759: from per_assignment_extra_info
3760: where assignment_id = p_assignment_id
3761: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
3762: and p_effective_date between -- Bug 5083240: Consider end date to be last day of contract_expiry_date year
3763: fnd_date.canonical_to_date(aei_information2)

Line 3905: from per_assignment_extra_info

3901: cursor csr_aei
3902: is
3903: select fnd_date.canonical_to_date(aei_information1),
3904: fnd_date.canonical_to_date(aei_information2)
3905: from per_assignment_extra_info
3906: where assignment_id = p_assignment_id
3907: and information_type = p_information_type;
3908: --
3909: cursor csr_get_emp_dates

Line 4087: From per_assignment_extra_info

4083: -- Bug 3172960
4084: Cursor csr_fixed_tax_rate
4085: IS
4086: Select aei_information1
4087: From per_assignment_extra_info
4088: Where assignment_id = p_assignment_id
4089: And information_type = 'KR_YEA_FOREIGN_WORKER_TAX';
4090: begin
4091: --