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

Line 473: AND period_end_date > TRUNC ( NVL ( l_payroll_end_date,fnd_date.canonical_to_date('1900/01/01')))-- added this and conditoin for bug 2836176

469: CURSOR sum_percent_cur IS --changed from sum to sum_percent_cur
470: SELECT sum(PERIOD_SCHEDULE_PERCENT)
471: FROM psp_matrix_driver
472: WHERE run_id = global_run_id
473: AND period_end_date > TRUNC ( NVL ( l_payroll_end_date,fnd_date.canonical_to_date('1900/01/01')))-- added this and conditoin for bug 2836176
474: GROUP BY period_start_date , period_end_date;
475:
476:
477: -- Bug 7634722

Line 484: AND period_end_date <= TRUNC ( NVL ( l_payroll_end_date,fnd_date.canonical_to_date('1900/01/01')))-- added this and conditoin for bug 2836176

480: CURSOR sum_percent_cur_left IS
481: SELECT sum(PERIOD_SCHEDULE_PERCENT)
482: FROM psp_matrix_driver
483: WHERE run_id = global_run_id
484: AND period_end_date <= TRUNC ( NVL ( l_payroll_end_date,fnd_date.canonical_to_date('1900/01/01')))-- added this and conditoin for bug 2836176
485: GROUP BY period_start_date , period_end_date;
486:
487:
488: