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

Line 5270: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_3)) >= ptp.start_date

5266: Psp_report_templates_h pth,
5267: Per_time_periods ptp
5268: Where ppc.run_id = p_run_id
5269: And ppc.time_period_id = ptp.time_period_id
5270: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_3)) >= ptp.start_date
5271: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_2)) <= ptp.end_date;
5272:
5273: cursor supercede_tolerance(p_template_id in integer) is
5274: select nvl(sprcd_tolerance_amt,-999),

Line 5271: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_2)) <= ptp.end_date;

5267: Per_time_periods ptp
5268: Where ppc.run_id = p_run_id
5269: And ppc.time_period_id = ptp.time_period_id
5270: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_3)) >= ptp.start_date
5271: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_2)) <= ptp.end_date;
5272:
5273: cursor supercede_tolerance(p_template_id in integer) is
5274: select nvl(sprcd_tolerance_amt,-999),
5275: nvl(sprcd_tolerance_percent,-999)