DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1728: FROM hr_all_organization_units hou,

1724: FROM po_system_parameters;
1725:
1726: SELECT hou.name
1727: INTO p_org_name
1728: FROM hr_all_organization_units hou,
1729: hr_all_organization_units_tl hout
1730: WHERE hou.organization_id = hout.organization_id
1731: AND hout.LANGUAGE = UserEnv('LANG')
1732: AND hou.organization_id = l_org_id;

Line 1729: hr_all_organization_units_tl hout

1725:
1726: SELECT hou.name
1727: INTO p_org_name
1728: FROM hr_all_organization_units hou,
1729: hr_all_organization_units_tl hout
1730: WHERE hou.organization_id = hout.organization_id
1731: AND hout.LANGUAGE = UserEnv('LANG')
1732: AND hou.organization_id = l_org_id;
1733: