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 5386: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;

5382: )
5383: IS
5384: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5385: l_project_number PA_PROJECTS_ALL.SEGMENT1%TYPE ;
5386: l_status_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE ;
5387: l_request_id PA_PROJ_ELEM_VER_STRUCTURE.CONC_REQUEST_ID%TYPE;
5388:
5389: l_debug_mode VARCHAR2(1);
5390: l_msg_count NUMBER ;

Line 5406: FROM PA_PROJECT_STATUSES pps,

5402: */
5403: -- THE FOLLOWING CURSOR WILL NOT BE USED ANYWHERE
5404: /*CURSOR c_project_sys_status_code IS
5405: SELECT PROJECT_SYSTEM_STATUS_CODE
5406: FROM PA_PROJECT_STATUSES pps,
5407: PA_PROJECTS_ALL pa
5408: WHERE pa.PROJECT_ID = p_project_id
5409: AND pps.PROJECT_STATUS_CODE = pa.PROJECT_STATUS_CODE ;
5410: */