APPS.PA_PROGRESS_UTILS dependencies on PA_PROJECT_STATUSES

Line 844: from pa_project_statuses po, pa_proj_progress_attr ppp, pa_proj_elements ppe -- Bug 4535784 Changed from pa_resource_types to pa_project_statuses

840: IS
841: SELECT trunc(p_as_of_date) FROM DUAL
842: MINUS
843: SELECT PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type, 'WORKPLAN', p_proj_element_id/* Amit : Modified for IB4 Progress CR. */) as_of_date
844: from pa_project_statuses po, pa_proj_progress_attr ppp, pa_proj_elements ppe -- Bug 4535784 Changed from pa_resource_types to pa_project_statuses
845: where ppe.project_id = ppp.project_id(+)
846: AND ppp.structure_type (+) = 'WORKPLAN'
847: and ppe.project_id= p_project_id
848: and ppe.proj_element_id = p_object_id

Line 1026: FROM pa_progress_rollup ppr, pa_project_statuses pps

1022: BASE_PERCENT_COMPLETE, EFF_ROLLUP_PERCENT_COMP,
1023: ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE,
1024: ACTUAL_START_DATE, ACTUAL_FINISH_DATE,
1025: pps.status_icon_ind, pps.status_icon_active_ind
1026: FROM pa_progress_rollup ppr, pa_project_statuses pps
1027: WHERE object_id = p_task_id
1028: AND project_id = l_project_id
1029: AND ppr.eff_rollup_prog_stat_code = pps.project_status_code(+)
1030: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup

Line 2261: pa_project_statuses pps

2257: SELECT ppe.status_code
2258: FROM pa_object_relationships por,
2259: pa_proj_element_versions ppev,
2260: pa_proj_elements ppe,
2261: pa_project_statuses pps
2262: WHERE object_id_to1 = p_object_version_id
2263: AND ppev.element_version_id = por.object_id_from1
2264: AND ppev.proj_element_id = ppe.proj_element_id
2265: AND ppev.object_type = ppe.object_type

Line 2315: FROM pa_project_statuses pps -----, fnd_lookup_values flv

2311:
2312: CURSOR cur_sys_status
2313: IS
2314: SELECT project_system_status_code
2315: FROM pa_project_statuses pps -----, fnd_lookup_values flv
2316: WHERE project_status_code = p_status_code
2317: AND status_type = decode(p_object_type, 'PA_TASKS', 'TASK', 'PA_DELIVERABLES', 'DELIVERABLE');
2318: /* bug 4699567 flv was not used in the query anyways
2319: AND lookup_type = decode(p_object_type, 'PA_TASKS', 'TASK_SYSTEM_STATUS', 'PA_DELIVERABLES', 'DELIVERABLE_SYSTEM_STATUS')

Line 11792: , pa_project_statuses status

11788: CURSOR cur_check_published_version(c_structure_version_id NUMBER, c_project_id NUMBER)
11789: IS
11790: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
11791: FROM pa_proj_elem_ver_structure str
11792: , pa_project_statuses status
11793: where str.element_version_id = c_structure_version_id
11794: AND str.project_id = c_project_id
11795: AND str.status_code = status.project_status_code;
11796:

Line 13303: FROM --pa_project_statuses po, --removed for bug 13687289

13299: SELECT as_of_date FROM (
13300: SELECT ppe.project_id project_id,
13301: PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type) as_of_date ,
13302: ppe.object_type object_type
13303: FROM --pa_project_statuses po, --removed for bug 13687289
13304: pa_proj_progress_attr ppp,
13305: pa_proj_elements ppe
13306: WHERE ppe.project_id = ppp.project_id(+)
13307: AND ppp.structure_type (+) = 'WORKPLAN'