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.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_LOOKUPS

Line 2057: pa_lookups pl,

2053:
2054: CURSOR get_report_info IS
2055: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2056: pa_progress_reports_v pprv,
2057: pa_lookups pl,
2058: pa_project_parties ppp,
2059: per_all_people_f papf
2060: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2061: AND pl.lookup_code = pprv.progress_status_code

Line 2072: pa_lookups pl

2068: and trunc(sysdate) between papf.effective_START_DATE and nvl(papf.effective_END_DATE, sysdate+1);
2069: /*
2070: SELECT pprv.*, pl.meaning progress_status FROM
2071: pa_progress_report_vers pprv,
2072: pa_lookups pl
2073: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2074: AND pl.lookup_code = pprv.progress_status_code
2075: and pprv.version_id = document_id
2076: AND pprv.object_type = 'PA_PROJECTS';*/

Line 2195: pa_lookups pl,

2191:
2192: CURSOR get_report_info IS
2193: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2194: pa_progress_reports_v pprv,
2195: pa_lookups pl,
2196: pa_project_parties ppp,
2197: per_all_people_f papf
2198: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2199: AND pl.lookup_code = pprv.progress_status_code

Line 2210: pa_lookups pl

2206: and trunc(sysdate) between papf.effective_START_DATE and nvl(papf.effective_END_DATE, sysdate+1);
2207: /*
2208: SELECT pprv.*, pl.meaning progress_status FROM
2209: pa_progress_report_vers pprv,
2210: pa_lookups pl
2211: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2212: AND pl.lookup_code = pprv.progress_status_code
2213: and pprv.version_id = document_id
2214: AND pprv.object_type = 'PA_PROJECTS';*/

Line 2345: pa_lookups pl,

2341:
2342: CURSOR get_report_info IS
2343: SELECT pprv.*, pl.meaning progress_status, papf.full_name FROM
2344: pa_progress_report_vers pprv,
2345: pa_lookups pl,
2346: pa_project_parties ppp,
2347: per_all_people_f papf
2348: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2349: AND pl.lookup_code = pprv.progress_status_code

Line 2371: pa_lookups pl

2367:
2368: /*
2369: SELECT pprv.*, pl.meaning progress_status FROM
2370: pa_progress_report_vers pprv,
2371: pa_lookups pl
2372: where lookup_type like 'PROGRESS_SYSTEM_STATUS'
2373: AND pl.lookup_code = pprv.progress_status_code
2374: and pprv.version_id = document_id
2375: AND pprv.object_type = 'PA_PROJECTS';*/