DBA Data[Home] [Help]

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: l_sum_percent NUMBER(5,2);
477: