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

Line 1675: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));

1671:
1672: END IF;
1673: /* Bug 5575567 */
1674: hr_utility.trace(' sysdate ' || sysdate);
1675: hr_utility.trace(' end of year ' || fnd_date.canonical_to_date(p_year||'/12/31'));
1676:
1677: /* Start : Bug # 8353425
1678: Considering the Session Date instead of System Date while fetching employee's
1679: name. The report will now take the employee's current name as of the application

Line 1686: fnd_date.canonical_to_date(p_year||'/12/31')) THEN

1682: name that was effective as of the last day of the year.
1683: Commenting the following If-Else condition.
1684:
1685: IF (trunc(sysdate) <
1686: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
1687: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
1688: ELSE
1689: p_effective_date := trunc(sysdate); --Bug 8222402
1690: END IF;

Line 1687: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');

1683: Commenting the following If-Else condition.
1684:
1685: IF (trunc(sysdate) <
1686: fnd_date.canonical_to_date(p_year||'/12/31')) THEN
1687: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
1688: ELSE
1689: p_effective_date := trunc(sysdate); --Bug 8222402
1690: END IF;
1691:

Line 1701: IF (trunc(nvl(c_get_session_date_rec.session_date,sysdate)) <= fnd_date.canonical_to_date(p_year||'/12/31')) THEN -- Bug 9073693

1697:
1698: /*Start Bug 9073693: Since Application session date is sysdate in case of selfservice,
1699: Replacing c_get_session_date_rec.session_date with sysdate if it is null */
1700:
1701: IF (trunc(nvl(c_get_session_date_rec.session_date,sysdate)) <= fnd_date.canonical_to_date(p_year||'/12/31')) THEN -- Bug 9073693
1702: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
1703: ELSE
1704: p_effective_date := trunc(nvl(c_get_session_date_rec.session_date,sysdate)); -- Bug 9073693
1705: END IF;

Line 1702: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');

1698: /*Start Bug 9073693: Since Application session date is sysdate in case of selfservice,
1699: Replacing c_get_session_date_rec.session_date with sysdate if it is null */
1700:
1701: IF (trunc(nvl(c_get_session_date_rec.session_date,sysdate)) <= fnd_date.canonical_to_date(p_year||'/12/31')) THEN -- Bug 9073693
1702: p_effective_date := fnd_date.canonical_to_date(p_year||'/12/31');
1703: ELSE
1704: p_effective_date := trunc(nvl(c_get_session_date_rec.session_date,sysdate)); -- Bug 9073693
1705: END IF;
1706: hr_utility.trace(' p_effective_date ' || p_effective_date);

Line 1941: l_state_tab(l_sl_total_count).state_ein_o := get_state_ein(l_state_tab(l_sl_total_count).jurisdiction_c,fnd_date.canonical_to_date(p_year||'/12/31'), p_tax_unit_id);

1937: --
1938:
1939: if nvl(l_state_tab(l_sl_total_count).state_ein_o ,'NO STATE EIN') = 'NO STATE EIN'
1940: OR nvl(l_state_tab(l_sl_total_count).state_ein_c ,'NO STATE EIN') = 'NO STATE EIN' then
1941: l_state_tab(l_sl_total_count).state_ein_o := get_state_ein(l_state_tab(l_sl_total_count).jurisdiction_c,fnd_date.canonical_to_date(p_year||'/12/31'), p_tax_unit_id);
1942: l_state_tab(l_sl_total_count).state_ein_c := l_state_tab(l_sl_total_count).state_ein_o;
1943: end if;
1944: end if;
1945: