APPS.PO_MASS_UPDATE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 75: x_org_name hr_all_organization_units.name%TYPE;

71: /** **/
72: /** tpoon 9/27/2002 **/
73: /** Changed x_org_name to use %TYPE **/
74: -- x_org_name varchar2(60);
75: x_org_name hr_all_organization_units.name%TYPE;
76:
77: x_po_count number := 0;
78: x_rel_count number := 0;
79: x_progress varchar2(3) := null;

Line 135: from hr_all_organization_units hou,

131: --If condition added by jbalakri for bug 2374299
132: if x_org_id is not null then
133: select hou.name
134: into x_org_name
135: from hr_all_organization_units hou,
136: hr_all_organization_units_tl hout
137: where hou.organization_id = hout.organization_id
138: and hout.language = userenv('LANG')
139: and hou.organization_id = x_org_id;

Line 136: hr_all_organization_units_tl hout

132: if x_org_id is not null then
133: select hou.name
134: into x_org_name
135: from hr_all_organization_units hou,
136: hr_all_organization_units_tl hout
137: where hou.organization_id = hout.organization_id
138: and hout.language = userenv('LANG')
139: and hou.organization_id = x_org_id;
140: end if;