DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_RESOURCE_TYPES

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

855: IS
856: SELECT trunc(p_as_of_date) FROM DUAL
857: MINUS
858: 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
859: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe
860: where ppe.project_id = ppp.project_id(+)
861: AND ppp.structure_type (+) = 'WORKPLAN'
862: and ppe.project_id= p_project_id
863: and ppe.resource_list_member_id = p_object_id /* Modified for IB4 Progress CR. */