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_PROJECT_PUB dependencies on PA_PROJECT_STATUSES

Line 471: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

467:
468: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
469: CURSOR c_prj(c_project_id IN NUMBER ) IS
470: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
471: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
472: where ppa.project_id = c_project_id
473: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
474: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
475: and pps.STATUS_TYPE = 'PROJECT'

Line 9875: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa

9871:
9872: -- Cursor to get the Project's System Status Code Bug 3611598
9873: CURSOR c_project_sys_status_code IS
9874: SELECT project_system_status_code
9875: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa
9876: WHERE pa.project_id = p_project_in.pa_project_id
9877: AND sta.project_status_code = pa.project_status_code;
9878:
9879: TYPE deferred_tasks_rec IS RECORD

Line 9889: l_status_code PA_PROJECT_STATUSES.project_system_status_code%TYPE; -- Bug 3611598

9885: l_dummy_calendar_id VARCHAR2(1) := 'N' ; -- Added for bug 5222506
9886: l_dummy_project_rate_type VARCHAR2(1) :='N'; -- Added For bug 5225146
9887: l_dummy_cur_retention_tax_code VARCHAR2(1) :='N';
9888: l_dummy_cur_output_tax_code VARCHAR2(1) :='N'; -- Added For Bug 5188246.
9889: l_status_code PA_PROJECT_STATUSES.project_system_status_code%TYPE; -- Bug 3611598
9890: l_deferred_tasks_index_tbl deferred_tasks_tbl_typ;
9891:
9892: l_project_rec pa_projects%ROWTYPE;
9893: l_project_in_rec pa_project_pub.project_in_rec_type;

Line 10246: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt

10242:
10243: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
10244: CURSOR c_prj(c_project_id IN NUMBER ) IS
10245: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
10246: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
10247: where ppa.project_id = c_project_id
10248: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
10249: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
10250: and pps.STATUS_TYPE = 'PROJECT'