APPS.PA_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PROJ_PROGRESS_ATTR

Line 588: pa_proj_progress_attr pppa

584: SELECT DECODE(ptt.REMAIN_EFFORT_ENABLE_FLAG, 'Y', DECODE(pppa.REMAIN_EFFORT_ENABLE_FLAG, 'Y', 'Y', 'N'), 'N')
585: INTO l_est_remaining_eff_flag
586: FROM pa_proj_elements ppe,
587: pa_task_types ptt ,
588: pa_proj_progress_attr pppa
589: WHERE ppe.proj_element_id = p_task_id
590: AND ppe.type_id = ptt.task_type_id
591: AND pppa.project_id = ppe.project_id
592: AND pppa.structure_type = 'WORKPLAN'; -- For Bug 8887270