APPS.PA_TASK_PUB1 dependencies on HR_ALL_ORGANIZATION_UNITS

Line 864: FROM pa_proj_elements pe, hr_all_organization_units hou

860: WHERE task_id = c_task_id;
861:
862: CURSOR cur_task_attr IS
863: SELECT pe.ELEMENT_NUMBER, pe.NAME, pe.DESCRIPTION, hou.name
864: FROM pa_proj_elements pe, hr_all_organization_units hou
865: WHERE pe.proj_element_id = p_task_id
866: AND pe.carrying_out_organization_id = hou.organization_id;
867:
868: --Bug 3940203 avaithia