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 FND_DATE

Line 6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');

2: /* $Header: pykryea.pkb 120.60.12020000.18 2013/01/15 12:20:48 scireddy ship $ */
3: ------------------------------------------------------------------------
4: -- Constants
5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');

Line 7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');

3: ------------------------------------------------------------------------
4: -- Constants
5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');

Line 8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');

4: -- Constants
5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313

Line 9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');

5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170

Line 10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');

6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136

Line 11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');

7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094

Line 12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313

8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094
16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732

Line 13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170

9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094
16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732
17: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01'); -- Bug 14219478

Line 14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136

10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094
16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732
17: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01'); -- Bug 14219478
18: ------------------------------------------------------------------------

Line 15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094

11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094
16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732
17: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01'); -- Bug 14219478
18: ------------------------------------------------------------------------
19: -- Global Variables

Line 16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732

12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094
16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732
17: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01'); -- Bug 14219478
18: ------------------------------------------------------------------------
19: -- Global Variables
20: ------------------------------------------------------------------------

Line 17: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01'); -- Bug 14219478

13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: c_20090101 constant date := fnd_date.canonical_to_date('2009/01/01'); -- Bug 7676136
15: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01'); -- Bug 9231094
16: c_20110101 constant date := fnd_date.canonical_to_date('2011/01/01'); -- Bug 9393732
17: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01'); -- Bug 14219478
18: ------------------------------------------------------------------------
19: -- Global Variables
20: ------------------------------------------------------------------------
21: g_package constant varchar2(31) := ' pay_kr_yea_pkg.';

Line 548: p_archive_item_value := fnd_date.canonical_to_date(l_archive_item_value_tbl(p_user_entity_id));

544: ----------------------------------------------------------------
545: is
546: begin
547: if l_archive_item_value_tbl.exists(p_user_entity_id) then
548: p_archive_item_value := fnd_date.canonical_to_date(l_archive_item_value_tbl(p_user_entity_id));
549: end if;
550: end set_archive_item;
551: begin
552: ------------------------------------------------------------------------

Line 1079: set_archive_item(p_user_entity_id, fnd_date.date_to_canonical(p_archive_item_value));

1075: p_archive_item_value in date)
1076: ----------------------------------------------------------------
1077: is
1078: begin
1079: set_archive_item(p_user_entity_id, fnd_date.date_to_canonical(p_archive_item_value));
1080: end set_archive_item;
1081: begin
1082: if p_report_type = g_archive_item.report_type
1083: and p_report_qualifier = g_archive_item.report_qualifier

Line 1672: fnd_date.canonical_to_date(aei_information15), -- Bug 8644512

1668: is
1669: cursor csr_aei is
1670: select hr_ni_chk_pkg.chk_nat_id_format(aei_information2, 'DDD-DD-DDDDD'),
1671: aei_information3,
1672: fnd_date.canonical_to_date(aei_information15), -- Bug 8644512
1673: fnd_date.canonical_to_date(aei_information16), -- Bug 8644512
1674: fnd_date.canonical_to_date(aei_information17), -- Bug 8644512
1675: fnd_date.canonical_to_date(aei_information18), -- Bug 8644512
1676: nvl(to_number(aei_information4), 0),

Line 1673: fnd_date.canonical_to_date(aei_information16), -- Bug 8644512

1669: cursor csr_aei is
1670: select hr_ni_chk_pkg.chk_nat_id_format(aei_information2, 'DDD-DD-DDDDD'),
1671: aei_information3,
1672: fnd_date.canonical_to_date(aei_information15), -- Bug 8644512
1673: fnd_date.canonical_to_date(aei_information16), -- Bug 8644512
1674: fnd_date.canonical_to_date(aei_information17), -- Bug 8644512
1675: fnd_date.canonical_to_date(aei_information18), -- Bug 8644512
1676: nvl(to_number(aei_information4), 0),
1677: nvl(to_number(aei_information5), 0),

Line 1674: fnd_date.canonical_to_date(aei_information17), -- Bug 8644512

1670: select hr_ni_chk_pkg.chk_nat_id_format(aei_information2, 'DDD-DD-DDDDD'),
1671: aei_information3,
1672: fnd_date.canonical_to_date(aei_information15), -- Bug 8644512
1673: fnd_date.canonical_to_date(aei_information16), -- Bug 8644512
1674: fnd_date.canonical_to_date(aei_information17), -- Bug 8644512
1675: fnd_date.canonical_to_date(aei_information18), -- Bug 8644512
1676: nvl(to_number(aei_information4), 0),
1677: nvl(to_number(aei_information5), 0),
1678: nvl(to_number(aei_information6), 0),

Line 1675: fnd_date.canonical_to_date(aei_information18), -- Bug 8644512

1671: aei_information3,
1672: fnd_date.canonical_to_date(aei_information15), -- Bug 8644512
1673: fnd_date.canonical_to_date(aei_information16), -- Bug 8644512
1674: fnd_date.canonical_to_date(aei_information17), -- Bug 8644512
1675: fnd_date.canonical_to_date(aei_information18), -- Bug 8644512
1676: nvl(to_number(aei_information4), 0),
1677: nvl(to_number(aei_information5), 0),
1678: nvl(to_number(aei_information6), 0),
1679: nvl(to_number(aei_information7), 0),

Line 1695: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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;
1697: begin
1698: open csr_aei;
1699: fetch csr_aei into

Line 1896: select fnd_date.canonical_to_date(aei_information23) aei23, -- Bug 8644512

1892: )
1893: ------------------------------------------------------------------------
1894: is
1895: cursor csr_aei is
1896: select fnd_date.canonical_to_date(aei_information23) aei23, -- Bug 8644512
1897: fnd_date.canonical_to_date(aei_information1) aei1,
1898: aei_information2 aei2,
1899: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD') aei3,
1900: fnd_date.canonical_to_date(aei_information24) aei24, -- Bug 8644512

Line 1897: fnd_date.canonical_to_date(aei_information1) aei1,

1893: ------------------------------------------------------------------------
1894: is
1895: cursor csr_aei is
1896: select fnd_date.canonical_to_date(aei_information23) aei23, -- Bug 8644512
1897: fnd_date.canonical_to_date(aei_information1) aei1,
1898: aei_information2 aei2,
1899: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD') aei3,
1900: fnd_date.canonical_to_date(aei_information24) aei24, -- Bug 8644512
1901: fnd_date.canonical_to_date(aei_information25) aei25, -- Bug 8644512

Line 1900: fnd_date.canonical_to_date(aei_information24) aei24, -- Bug 8644512

1896: select fnd_date.canonical_to_date(aei_information23) aei23, -- Bug 8644512
1897: fnd_date.canonical_to_date(aei_information1) aei1,
1898: aei_information2 aei2,
1899: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD') aei3,
1900: fnd_date.canonical_to_date(aei_information24) aei24, -- Bug 8644512
1901: fnd_date.canonical_to_date(aei_information25) aei25, -- Bug 8644512
1902: nvl(to_number(aei_information4), 0) aei4,
1903: nvl(to_number(aei_information5), 0) aei5,
1904: nvl(to_number(aei_information6), 0) aei6,

Line 1901: fnd_date.canonical_to_date(aei_information25) aei25, -- Bug 8644512

1897: fnd_date.canonical_to_date(aei_information1) aei1,
1898: aei_information2 aei2,
1899: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD') aei3,
1900: fnd_date.canonical_to_date(aei_information24) aei24, -- Bug 8644512
1901: fnd_date.canonical_to_date(aei_information25) aei25, -- Bug 8644512
1902: nvl(to_number(aei_information4), 0) aei4,
1903: nvl(to_number(aei_information5), 0) aei5,
1904: nvl(to_number(aei_information6), 0) aei6,
1905: nvl(to_number(aei_information7), 0) aei7,

Line 1929: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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;
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,

Line 1939: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
1940: order by 1;
1941: cnt number;
1942: l_assignment_extra_info_id number;
1943: l_dummy number;

Line 2122: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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);
2124: cnt number;
2125: begin
2126:

Line 2157: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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);
2159: cnt number;
2160: begin
2161: open csr;

Line 2190: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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);
2192: cnt number;
2193: begin
2194: open csr;

Line 2223: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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);
2225: cnt number;
2226: begin
2227: open csr;

Line 2253: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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;
2255:
2256: j number;
2257: --

Line 2292: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2293: order by aei_information2;
2294:
2295: cursor csr_pledt_details_ordby_latest is
2296: select

Line 2304: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2305: order by aei_information2 desc;
2306:
2307: -- Bug 16094871
2308: cursor csr_pledt_don_current is

Line 2316: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2317: and to_number(aei_information2) = to_number(to_char(p_effective_date, 'YYYY'))
2318: order by donated_year;
2319:
2320: cursor csr_pledt_don_carry_over is

Line 2328: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2329: and to_number(aei_information2) <> to_number(to_char(p_effective_date, 'YYYY'))
2330: order by donated_year;
2331:
2332: cnt number := 1;

Line 2399: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2400: order by aei_information2;
2401:
2402: cursor csr_tlaw_details_ordby_latest is
2403: select

Line 2411: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2412: order by aei_information2 desc;
2413:
2414: -- Bug 16094871
2415: cursor csr_tlaw_don_current is

Line 2423: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2424: and to_number(aei_information2) = to_number(to_char(p_effective_date, 'YYYY'))
2425: order by donated_year;
2426:
2427: cursor csr_tlaw_don_carry_over is

Line 2435: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2436: and to_number(aei_information2) <> to_number(to_char(p_effective_date, 'YYYY'))
2437: order by donated_year;
2438:
2439: cnt number := 1;

Line 2506: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2507: order by aei_information2;
2508:
2509: cursor csr_stat_details_ordby_latest is
2510: select

Line 2518: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2519: order by aei_information2 desc;
2520: -- Bug 16094871
2521: cursor csr_stat_don_current is
2522: select assignment_extra_info_id asg_info_id,

Line 2529: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2530: and to_number(aei_information2) = to_number(to_char(p_effective_date, 'YYYY'))
2531: order by donated_year;
2532:
2533: cursor csr_stat_don_carry_over is

Line 2541: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2542: and to_number(aei_information2) <> to_number(to_char(p_effective_date, 'YYYY'))
2543: order by donated_year;
2544:
2545: cnt number := 1;

Line 2611: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2612: order by aei_information2;
2613: --
2614: begin
2615: --

Line 2651: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2652: order by aei_information2;
2653: --
2654: begin
2655: --

Line 2740: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2741: group by to_number(aei_information2)
2742: order by to_number(aei_information2);
2743: --
2744: cursor csr_rel_details is

Line 2753: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2754: group by to_number(aei_information2)
2755: order by to_number(aei_information2);
2756:
2757:

Line 2833: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2834: order by to_number(aei_information8), aei_information2;
2835:
2836: cursor csr_spec_rel_ordby_new_don is
2837: select

Line 2846: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2847: order by to_number(aei_information8) , aei_information2 desc;
2848: --
2849: -- to select current and carryover years..
2850: cursor csr_spec_rel_year is

Line 2857: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2858: order by aei_information2 desc) where rownum <=2;
2859:
2860: cursor csr_spec_rel_don_current is
2861: select assignment_extra_info_id asg_info_id,

Line 2869: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2870: and to_number(aei_information2) = to_number(to_char(p_effective_date, 'YYYY'))
2871: order by donation_code;
2872:
2873: cursor csr_spec_rel_don_carry_over is

Line 2882: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
2883: and to_number(aei_information2) <> to_number(to_char(p_effective_date, 'YYYY'))
2884: order by donation_code, donated_year;
2885:
2886: l_flag varchar(1) := 'N';

Line 3021: fnd_date.canonical_to_date(aei_information13),

3017: nvl(to_number(aei_information7), 0),
3018: nvl(to_number(aei_information8), 0),
3019: nvl(to_number(aei_information9), 0),
3020: nvl(to_number(aei_information10), 0),
3021: fnd_date.canonical_to_date(aei_information13),
3022: fnd_date.canonical_to_date(aei_information14),
3023: nvl(to_number(aei_information15), 0),
3024: fnd_date.canonical_to_date(aei_information16),
3025: nvl(to_number(aei_information17), 0),

Line 3022: fnd_date.canonical_to_date(aei_information14),

3018: nvl(to_number(aei_information8), 0),
3019: nvl(to_number(aei_information9), 0),
3020: nvl(to_number(aei_information10), 0),
3021: fnd_date.canonical_to_date(aei_information13),
3022: fnd_date.canonical_to_date(aei_information14),
3023: nvl(to_number(aei_information15), 0),
3024: fnd_date.canonical_to_date(aei_information16),
3025: nvl(to_number(aei_information17), 0),
3026: fnd_date.canonical_to_date(aei_information25),

Line 3024: fnd_date.canonical_to_date(aei_information16),

3020: nvl(to_number(aei_information10), 0),
3021: fnd_date.canonical_to_date(aei_information13),
3022: fnd_date.canonical_to_date(aei_information14),
3023: nvl(to_number(aei_information15), 0),
3024: fnd_date.canonical_to_date(aei_information16),
3025: nvl(to_number(aei_information17), 0),
3026: fnd_date.canonical_to_date(aei_information25),
3027: nvl(to_number(aei_information26), 0),
3028: nvl(to_number(aei_information18), 0), -- Statutory (100%)

Line 3026: fnd_date.canonical_to_date(aei_information25),

3022: fnd_date.canonical_to_date(aei_information14),
3023: nvl(to_number(aei_information15), 0),
3024: fnd_date.canonical_to_date(aei_information16),
3025: nvl(to_number(aei_information17), 0),
3026: fnd_date.canonical_to_date(aei_information25),
3027: nvl(to_number(aei_information26), 0),
3028: nvl(to_number(aei_information18), 0), -- Statutory (100%)
3029: nvl(to_number(aei_information19), 0), -- Political (100,000 Limit)
3030: nvl(to_number(aei_information20), 0), -- Political (100%)

Line 3045: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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:
3047: cursor csr_aei2 is
3048: select nvl(to_number(aei_information2), 0) -- Bug 3971542 Employee's occupational training (educational) expense
3049: ,nvl(to_number(aei_information3), 0) -- Bug 4704848

Line 3055: ,fnd_date.canonical_to_date(aei_information12) -- Bug 8237227

3051: ,nvl(to_number(aei_information5), 0)
3052: ,nvl(aei_information10,'N') -- Bug 6737106 Check Box Medical Total and Details
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'

Line 3060: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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:
3062: cursor csr_sp3 is
3063: select
3064: fnd_date.canonical_to_date(aei_information2),

Line 3064: fnd_date.canonical_to_date(aei_information2),

3060: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3061:
3062: cursor csr_sp3 is
3063: select
3064: fnd_date.canonical_to_date(aei_information2),
3065: fnd_date.canonical_to_date(aei_information3),
3066: nvl(to_number(aei_information4), 0),
3067: aei_information5, -- Bug 13247926
3068: nvl(to_number(aei_information6),0), -- Bug 14754836

Line 3065: fnd_date.canonical_to_date(aei_information3),

3061:
3062: cursor csr_sp3 is
3063: select
3064: fnd_date.canonical_to_date(aei_information2),
3065: fnd_date.canonical_to_date(aei_information3),
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

Line 3073: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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: --
3075: -- Bug 5255234 Cursor to get the dependent Insurnace Expenses.
3076: --
3077: -- Bug 5879106

Line 3121: decode(pay_kr_ff_functions_pkg.aged_flag(aei_information8, fnd_date.canonical_to_date(to_char(p_effective_date, 'YYYY')||'/12/31')),'Y', (nvl(aei_information3,0) + nvl(aei_information11,0)),0

3117: -- Bug 9079450: The medical expense exemption for aged dependents
3118: -- will be given if age is 65 or older.
3119: ,nvl(sum(decode(aei_information7,0,0,decode(aei_information9,'B',
3120: decode(sign(to_char(p_effective_date, 'YYYY')-2008),1,
3121: decode(pay_kr_ff_functions_pkg.aged_flag(aei_information8, fnd_date.canonical_to_date(to_char(p_effective_date, 'YYYY')||'/12/31')),'Y', (nvl(aei_information3,0) + nvl(aei_information11,0)),0
3122: ),(nvl(aei_information3,0) + nvl(aei_information11,0))
3123: )
3124: )
3125: )

Line 3133: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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:
3135: -- Bug 9393732
3136: cursor csr_get_termination_info is
3137: Select decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -

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

3133: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
3134:
3135: -- Bug 9393732
3136: cursor csr_get_termination_info is
3137: Select decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -
3138: to_number(to_char(p_effective_date,'YYYY')) ),1,'Y',0,'N','N') create_donation_record
3139: from per_periods_of_service pds,
3140: per_assignments_f asg
3141: where asg.assignment_id = p_assignment_id

Line 3151: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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:
3153: begin
3154: --
3155: if g_debug then

Line 3299: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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
3301: begin
3302: open csr_aei;
3303: fetch csr_aei bulk collect into

Line 3327: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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
3329: open csr_aei;
3330: fetch csr_aei into
3331: p_educ_expense,

Line 3351: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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
3353: open csr_aei;
3354: fetch csr_aei bulk collect into
3355: p_saving_type_tbl,

Line 3474: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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:
3476: -- Bug 14219478 Start
3477: cursor csr_aei2 is
3478: select

Line 3491: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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
3493:
3494: -- Bug 9079450
3495: cursor csr_get_join_leave_info is

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

3494: -- Bug 9079450
3495: cursor csr_get_join_leave_info is
3496: Select decode(sign(to_number(to_char(pds.date_start,'YYYY')) -
3497: (to_number(to_char(p_effective_date,'YYYY'))-1)),1,'X',0,'Y','N') Joined_last_year,
3498: decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -
3499: to_number(to_char(p_effective_date,'YYYY'))),1,'N',0,'Y','X') Leaving_cur_year,
3500: asg.business_group_id bus_grp_id
3501: from per_periods_of_service pds,
3502: per_assignments_f asg

Line 3679: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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
3681: open csr_aei;
3682: fetch csr_aei into
3683: p_housing_loan_interest_repay,

Line 3706: select fnd_date.canonical_to_date(aei_information1),

3702: p_submission_date in out nocopy date)
3703: ------------------------------------------------------------------------
3704: is
3705: cursor csr_aei is
3706: select fnd_date.canonical_to_date(aei_information1),
3707: aei_information2,
3708: aei_information3,
3709: nvl(to_number(aei_information4), 0),
3710: nvl(to_number(aei_information5), 0),

Line 3714: fnd_date.canonical_to_date(aei_information9),

3710: nvl(to_number(aei_information5), 0),
3711: nvl(to_number(aei_information6), 0),
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'

Line 3715: fnd_date.canonical_to_date(aei_information10)

3711: nvl(to_number(aei_information6), 0),
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');

Line 3719: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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
3721: open csr_aei;
3722: fetch csr_aei into
3723: p_tax_paid_date,

Line 3755: fnd_date.canonical_to_date(aei_information2),

3751: ------------------------------------------------------------------------
3752: is
3753: cursor csr_aei is
3754: select aei_information1,
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

Line 3756: fnd_date.canonical_to_date(aei_information3),

3752: is
3753: cursor csr_aei is
3754: select aei_information1,
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

Line 3757: fnd_date.canonical_to_date(aei_information5),

3753: cursor csr_aei is
3754: select aei_information1,
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'

Line 3758: fnd_date.canonical_to_date(aei_information6)

3754: select aei_information1,
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

Line 3763: fnd_date.canonical_to_date(aei_information2)

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)
3764: and (add_months(trunc(fnd_date.canonical_to_date(aei_information3), 'YYYY'), 12) - 1) ;
3765: --
3766: --
3767: cursor csr_fw_contract_earn(

Line 3764: and (add_months(trunc(fnd_date.canonical_to_date(aei_information3), 'YYYY'), 12) - 1) ;

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)
3764: and (add_months(trunc(fnd_date.canonical_to_date(aei_information3), 'YYYY'), 12) - 1) ;
3765: --
3766: --
3767: cursor csr_fw_contract_earn(
3768: p_contr_start_date date,

Line 3903: select fnd_date.canonical_to_date(aei_information1),

3899: ------------------------------------------------------------------------
3900: is
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;

Line 3904: fnd_date.canonical_to_date(aei_information2)

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

Line 5757: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_displaydate(l_effective_date));

5753: close csr_archive_exists;
5754:
5755: if l_effective_date > p_effective_date then
5756: fnd_message.set_name('PAY', 'PAY_KR_YEA_ALREADY_PROCESSED');
5757: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_displaydate(l_effective_date));
5758: p_error := fnd_message.get;
5759: return;
5760: else
5761: if p_report_category in ('N', 'I') then