APPS.PA_PROGRESS_PUB dependencies on PA_PROJECT_STATUSES

Line 353: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

349: ( c_structure_version_id number
350: , c_project_id number
351: )IS
352: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
353: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
354: where str.element_version_id = c_structure_version_id
355: AND str.project_id = c_project_id
356: AND str.status_code = status.project_status_code;
357:

Line 1071: FROM pa_project_statuses

1067: IF (p_calling_module = 'AMG')
1068: THEN
1069: BEGIN
1070: SELECT 'x' INTO l_dummy
1071: FROM pa_project_statuses
1072: WHERE status_type = 'PROGRESS'
1073: AND project_status_code = p_progress_status_code;
1074: EXCEPTION
1075: WHEN NO_DATA_FOUND THEN

Line 11826: L_SYSTEM_STATUS_CODE pa_project_statuses.project_system_status_code%TYPE;

11822: L_ESTIMATED_START_DATE DATE;
11823: L_ESTIMATED_FINISH_DATE DATE;
11824: L_TASK_STATUS pa_percent_completes.status_code%TYPE;
11825: L_PERCENT_COMPLETE_ID NUMBER;
11826: L_SYSTEM_STATUS_CODE pa_project_statuses.project_system_status_code%TYPE;
11827: L_PROGRESS_ROLLUP_ID NUMBER;
11828: L_BAC_VALUE NUMBER;
11829: L_EARNED_VALUE NUMBER;
11830: L_PROG_PA_PERIOD_NAME pa_progress_rollup.PROG_PA_PERIOD_NAME%TYPE;

Line 19973: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

19969:
19970: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
19971: IS
19972: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
19973: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
19974: where str.element_version_id = c_structure_version_id
19975: AND str.project_id = c_project_id
19976: AND str.status_code = status.project_status_code;
19977:

Line 20923: , pa_project_statuses status

20919: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
20920: IS
20921: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
20922: FROM pa_proj_elem_ver_structure str
20923: , pa_project_statuses status
20924: where str.element_version_id = c_structure_version_id
20925: AND str.project_id = c_project_id
20926: AND str.status_code = status.project_status_code;
20927: