APPS.PO_MASS_UPDATE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 76: x_org_name hr_all_organization_units.name%TYPE;

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

Line 136: from hr_all_organization_units hou,

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

Line 137: hr_all_organization_units_tl hout

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