APPS.PA_PROGRESS_PUB dependencies on PA_PROJECT_STATUSES

Line 352: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

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

Line 1012: FROM pa_project_statuses

1008: IF (p_calling_module = 'AMG')
1009: THEN
1010: BEGIN
1011: SELECT 'x' INTO l_dummy
1012: FROM pa_project_statuses
1013: WHERE status_type = 'PROGRESS'
1014: AND project_status_code = p_progress_status_code;
1015: EXCEPTION
1016: WHEN NO_DATA_FOUND THEN

Line 11376: L_SYSTEM_STATUS_CODE pa_project_statuses.project_system_status_code%TYPE;

11372: L_ESTIMATED_START_DATE DATE;
11373: L_ESTIMATED_FINISH_DATE DATE;
11374: L_TASK_STATUS pa_percent_completes.status_code%TYPE;
11375: L_PERCENT_COMPLETE_ID NUMBER;
11376: L_SYSTEM_STATUS_CODE pa_project_statuses.project_system_status_code%TYPE;
11377: L_PROGRESS_ROLLUP_ID NUMBER;
11378: L_BAC_VALUE NUMBER;
11379: L_EARNED_VALUE NUMBER;
11380: L_PROG_PA_PERIOD_NAME pa_progress_rollup.PROG_PA_PERIOD_NAME%TYPE;

Line 18528: FROM pa_proj_elem_ver_structure str, pa_project_statuses status

18524:
18525: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
18526: IS
18527: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
18528: FROM pa_proj_elem_ver_structure str, pa_project_statuses status
18529: where str.element_version_id = c_structure_version_id
18530: AND str.project_id = c_project_id
18531: AND str.status_code = status.project_status_code;
18532:

Line 19460: , pa_project_statuses status

19456: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
19457: IS
19458: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
19459: FROM pa_proj_elem_ver_structure str
19460: , pa_project_statuses status
19461: where str.element_version_id = c_structure_version_id
19462: AND str.project_id = c_project_id
19463: AND str.status_code = status.project_status_code;
19464: