DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_PROGRESS_REPORT_VALS

Line 2049: from pa_progress_report_vals prval, pa_progress_report_vers prver

2045: l_reported_by_id NUMBER;
2046:
2047: cursor pr_vals is
2048: select prval.version_id,prver.overview briefoverview, prval.attribute1 summary,prval.attribute2 issues,prval.attribute3 accomplishments,prval.attribute4 plans
2049: from pa_progress_report_vals prval, pa_progress_report_vers prver
2050: where prval.version_id = document_id
2051: and prver.version_id = document_id
2052: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2053:

Line 2187: from pa_progress_report_vals prval, pa_progress_report_vers prver

2183: l_reported_by_id NUMBER;
2184: l_comment VARCHAR2(240);
2185: cursor pr_vals is
2186: select prval.version_id,prver.overview briefoverview, prval.attribute1 summary,prval.attribute2 issues,prval.attribute3 accomplishments,prval.attribute4 plans
2187: from pa_progress_report_vals prval, pa_progress_report_vers prver
2188: where prval.version_id = document_id
2189: and prver.version_id = document_id
2190: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2191:

Line 2337: from pa_progress_report_vals prval, pa_progress_report_vers prver

2333: l_submitter_name VARCHAR2(200);
2334:
2335: cursor pr_vals is
2336: select prval.version_id,prver.overview briefoverview, prval.attribute1 summary,prval.attribute2 issues,prval.attribute3 accomplishments,prval.attribute4 plans
2337: from pa_progress_report_vals prval, pa_progress_report_vers prver
2338: where prval.version_id = document_id
2339: and prver.version_id = document_id
2340: and region_code = 'PA_PROGRESS_GENERAL_TOP';
2341: