DBA Data[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