APPS.PA_DELIVERABLE_PVT dependencies on PA_PROJECT_STATUSES

Line 806: PA_PROJECT_STATUSES PPS

802: IS
803: SELECT
804: PPS.PROJECT_SYSTEM_STATUS_CODE
805: FROM
806: PA_PROJECT_STATUSES PPS
807: WHERE
808: PPS.PROJECT_STATUS_CODE = p_status_code;
809:
810: CURSOR l_proj_sch_ver_info_csr

Line 3821: FROM PA_PROJECT_STATUSES pps,

3817: SELECT pa.project_type
3818: ,pa.project_status_code
3819: ,project_system_status_code
3820: ,segment1 -- 3671408 added column to retrieve project number
3821: FROM PA_PROJECT_STATUSES pps,
3822: PA_PROJECTS_ALL pa
3823: WHERE pa.PROJECT_ID = p_target_project_id
3824: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
3825:

Line 3826: l_project_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

3822: PA_PROJECTS_ALL pa
3823: WHERE pa.PROJECT_ID = p_target_project_id
3824: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
3825:
3826: l_project_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
3827: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
3828: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
3829:
3830: l_item_type VARCHAR2(30);

Line 3827: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

3823: WHERE pa.PROJECT_ID = p_target_project_id
3824: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
3825:
3826: l_project_sys_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
3827: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
3828: l_project_type PA_PROJECTS_ALL.PROJECT_TYPE%TYPE;
3829:
3830: l_item_type VARCHAR2(30);
3831: l_wf_process VARCHAR2(30);