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.PQP_EXPREPLOD_PKG dependencies on FND_DATE

Line 1275: SELECT fnd_date.canonical_to_date(to_char(p_effective_date,'YYYY') ||

1271: Hr_Utility.set_location('l_tax_year_start '||l_tax_year_start, 5);
1272:
1273:
1274: IF l_tax_year_start IS NOT NULL THEN
1275: SELECT fnd_date.canonical_to_date(to_char(p_effective_date,'YYYY') ||
1276: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))
1277: INTO l_tax_year_start_dt from dual;
1278:
1279: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')

Line 1276: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))

1272:
1273:
1274: IF l_tax_year_start IS NOT NULL THEN
1275: SELECT fnd_date.canonical_to_date(to_char(p_effective_date,'YYYY') ||
1276: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))
1277: INTO l_tax_year_start_dt from dual;
1278:
1279: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1280: --INTO l_tax_year_start_dt from dual;