DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2760: FROM hr_all_organization_units hou,

2756: FROM po_system_parameters;
2757:
2758: SELECT hou.name
2759: INTO p_org_name
2760: FROM hr_all_organization_units hou,
2761: hr_all_organization_units_tl hout
2762: WHERE hou.organization_id = hout.organization_id
2763: AND hout.LANGUAGE = UserEnv('LANG')
2764: AND hou.organization_id = l_org_id;

Line 2761: hr_all_organization_units_tl hout

2757:
2758: SELECT hou.name
2759: INTO p_org_name
2760: FROM hr_all_organization_units hou,
2761: hr_all_organization_units_tl hout
2762: WHERE hou.organization_id = hout.organization_id
2763: AND hout.LANGUAGE = UserEnv('LANG')
2764: AND hou.organization_id = l_org_id;
2765: