DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_RESOURCE_TYPES

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 862: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe

858: IS
859: SELECT trunc(p_as_of_date) FROM DUAL
860: MINUS
861: SELECT PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.resource_list_member_id, ppp.progress_cycle_id, 'PA_ASSIGNMENTS', 'WORKPLAN', p_proj_element_id/* Amit : Modified for IB4 Progress CR. */) as_of_date
862: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe
863: where ppe.project_id = ppp.project_id(+)
864: AND ppp.structure_type (+) = 'WORKPLAN'
865: and ppe.project_id= p_project_id
866: and ppe.resource_list_member_id = p_object_id /* Modified for IB4 Progress CR. */