APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_STATUSES

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

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

Line 10127: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa

10123:
10124: -- Cursor to get the Project's System Status Code Bug 3611598
10125: CURSOR c_project_sys_status_code IS
10126: SELECT project_system_status_code
10127: FROM PA_PROJECT_STATUSES sta,PA_PROJECTS_ALL pa
10128: WHERE pa.project_id = p_project_in.pa_project_id
10129: AND sta.project_status_code = pa.project_status_code;
10130:
10131: Cursor c_adj_on_std_inv (p_adj_on_std_inv IN VARCHAR2)

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

10146: l_dummy_calendar_id VARCHAR2(1) := 'N' ; -- Added for bug 5222506
10147: l_dummy_project_rate_type VARCHAR2(1) :='N'; -- Added For bug 5225146
10148: l_dummy_cur_retention_tax_code VARCHAR2(1) :='N';
10149: l_dummy_cur_output_tax_code VARCHAR2(1) :='N'; -- Added For Bug 5188246.
10150: l_status_code PA_PROJECT_STATUSES.project_system_status_code%TYPE; -- Bug 3611598
10151: l_deferred_tasks_index_tbl deferred_tasks_tbl_typ;
10152:
10153: l_project_rec pa_projects%ROWTYPE;
10154: l_project_in_rec pa_project_pub.project_in_rec_type;

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

10504:
10505: -- Added the following cursor instead of the commented one as above for Performance Bug 4878696
10506: CURSOR c_prj(c_project_id IN NUMBER ) IS
10507: select PROJECT_SYSTEM_STATUS_CODE , PROJECT_TYPE_CLASS_CODE
10508: from pa_projects_all ppa,pa_project_statuses pps,pa_project_types ppt
10509: where ppa.project_id = c_project_id
10510: and ppa.PROJECT_STATUS_CODE = pps.PROJECT_STATUS_CODE
10511: and ppa.PROJECT_TYPE = ppt.PROJECT_TYPE
10512: and pps.STATUS_TYPE = 'PROJECT'

Line 10877: FROM pa_project_statuses pps

10873: l_new_sys_status VARCHAR2(30);
10874:
10875: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
10876: SELECT pps.project_system_status_code
10877: FROM pa_project_statuses pps
10878: WHERE pps.project_status_code = nvl(c_status_code,' ');
10879:
10880: /*Adding new cursor for bug 10043448 */
10881: CURSOR cur_inv_date(x_task_id pa_tasks.task_id%type) IS