2052: and region_code = 'PA_PROGRESS_GENERAL_TOP';
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'
2190: and region_code = 'PA_PROGRESS_GENERAL_TOP';
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'