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_ARCHIVE_RETRIEVE dependencies on PSP_EFFORT_REPORT_DETAILS

Line 61: -- PSP_EFFORT_REPORT_DETAILS PERD,

57: -- (
58: -- SELECT DISTINCT PER.effort_report_id,
59: -- PER.version_num
60: -- FROM PSP_EFFORT_REPORTS PER,
61: -- PSP_EFFORT_REPORT_DETAILS PERD,
62: -- PER_ASSIGNMENTS_F PAF,
63: -- PER_TIME_PERIODS PTP1,
64: -- PER_TIME_PERIODS PTP2,
65: -- PSP_EFFORT_REPORT_PERIODS PERP,

Line 94: PSP_EFFORT_REPORT_DETAILS PERD,

90: AND PTP.time_period_id >= p_begin_period
91: AND PTP.time_period_id <= p_end_period
92: AND EXISTS (SELECT 1
93: FROM PSP_EFFORT_REPORTS PER,
94: PSP_EFFORT_REPORT_DETAILS PERD,
95: PER_ASSIGNMENTS_F PAF,
96: PSP_EFFORT_REPORT_PERIODS PERP,
97: PSP_EFFORT_REPORT_TEMPLATES PERT
98: WHERE PER.status_code <> 'C'