APPS.PA_PROGRESS_UTILS dependencies on PA_PROJECT_STATUSES

Line 841: 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

837: IS
838: SELECT trunc(p_as_of_date) FROM DUAL
839: MINUS
840: 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
841: 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
842: where ppe.project_id = ppp.project_id(+)
843: AND ppp.structure_type (+) = 'WORKPLAN'
844: and ppe.project_id= p_project_id
845: and ppe.proj_element_id = p_object_id

Line 1022: FROM pa_progress_rollup ppr, pa_project_statuses pps

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

Line 2237: pa_project_statuses pps

2233: SELECT ppe.status_code
2234: FROM pa_object_relationships por,
2235: pa_proj_element_versions ppev,
2236: pa_proj_elements ppe,
2237: pa_project_statuses pps
2238: WHERE object_id_to1 = p_object_version_id
2239: AND ppev.element_version_id = por.object_id_from1
2240: AND ppev.proj_element_id = ppe.proj_element_id
2241: AND ppev.object_type = ppe.object_type

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

2287:
2288: CURSOR cur_sys_status
2289: IS
2290: SELECT project_system_status_code
2291: FROM pa_project_statuses pps -----, fnd_lookup_values flv
2292: WHERE project_status_code = p_status_code
2293: AND status_type = decode(p_object_type, 'PA_TASKS', 'TASK', 'PA_DELIVERABLES', 'DELIVERABLE');
2294: /* bug 4699567 flv was not used in the query anyways
2295: AND lookup_type = decode(p_object_type, 'PA_TASKS', 'TASK_SYSTEM_STATUS', 'PA_DELIVERABLES', 'DELIVERABLE_SYSTEM_STATUS')

Line 11712: , pa_project_statuses status

11708: CURSOR cur_check_published_version(c_structure_version_id NUMBER, c_project_id NUMBER)
11709: IS
11710: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED', 'Y', 'N')
11711: FROM pa_proj_elem_ver_structure str
11712: , pa_project_statuses status
11713: where str.element_version_id = c_structure_version_id
11714: AND str.project_id = c_project_id
11715: AND str.status_code = status.project_status_code;
11716:

Line 13206: FROM pa_project_statuses po,

13202: SELECT as_of_date FROM (
13203: SELECT ppe.project_id project_id,
13204: PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type) as_of_date ,
13205: ppe.object_type object_type
13206: FROM pa_project_statuses po,
13207: pa_proj_progress_attr ppp,
13208: pa_proj_elements ppe
13209: WHERE ppe.project_id = ppp.project_id(+)
13210: AND ppp.structure_type (+) = 'WORKPLAN'