DBA Data[Home] [Help]

APPS.PO_MASS_CLOSE_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 105: FROM hr_all_organization_units hou,

101: FROM po_system_parameters;
102:
103: SELECT hou.name
104: INTO p_org_name
105: FROM hr_all_organization_units hou,
106: hr_all_organization_units_tl hout
107: WHERE hou.organization_id = hout.organization_id
108: AND hout.LANGUAGE = UserEnv('LANG')
109: AND hou.organization_id = l_org_id;

Line 106: hr_all_organization_units_tl hout

102:
103: SELECT hou.name
104: INTO p_org_name
105: FROM hr_all_organization_units hou,
106: hr_all_organization_units_tl hout
107: WHERE hou.organization_id = hout.organization_id
108: AND hout.LANGUAGE = UserEnv('LANG')
109: AND hou.organization_id = l_org_id;
110: