APPS.PA_ACTIONS_PUB dependencies on PA_PROJECT_STATUSES

Line 1508: FROM pa_project_statuses pps,

1504: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
1505:
1506: CURSOR c_completed_flag (c_action_id IN pa_proj_elements.proj_element_id%TYPE)IS
1507: SELECT decode(pps.project_system_status_code,'DLVR_COMPLETED','Y','N')
1508: FROM pa_project_statuses pps,
1509: pa_proj_elements ppe
1510: WHERE ppe.proj_element_id = c_action_id
1511: AND pps.project_status_code = ppe.status_code ;
1512:

Line 5317: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;

5313: )
5314: IS
5315: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5316: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5317: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;
5318: l_request_id PA_PROJ_ELEM_VER_STRUCTURE.CONC_REQUEST_ID%TYPE;
5319:
5320: l_debug_mode VARCHAR2(1);
5321: l_msg_count NUMBER ;

Line 5337: FROM PA_PROJECT_STATUSES pps,

5333: */
5334: -- THE FOLLOWING CURSOR WILL NOT BE USED ANYWHERE
5335: /*CURSOR c_project_sys_status_code IS
5336: SELECT PROJECT_SYSTEM_STATUS_CODE
5337: FROM PA_PROJECT_STATUSES pps,
5338: PA_PROJECTS_ALL pa
5339: WHERE pa.PROJECT_ID = p_project_id
5340: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
5341: */