[Home] [Help]
APPS.PA_TASK_PUB1 dependencies on HR_ALL_ORGANIZATION_UNITS
Line 875: FROM pa_proj_elements pe, hr_all_organization_units hou
871: WHERE task_id = c_task_id;
872:
873: CURSOR cur_task_attr IS
874: SELECT pe.ELEMENT_NUMBER, pe.NAME, pe.DESCRIPTION, hou.name
875: FROM pa_proj_elements pe, hr_all_organization_units hou
876: WHERE pe.proj_element_id = p_task_id
877: AND pe.carrying_out_organization_id = hou.organization_id;
878:
879: --Bug 3940203 avaithia