APPS.PA_PAXEXCPS_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 149: v_ou_name hr_all_organization_units_tl.name%type;

145:
146:
147:
148:
149: v_ou_name hr_all_organization_units_tl.name%type;
150:
151: BEGIN
152: select substr(hr.name,1,60)
153: into v_ou_name

Line 154: from hr_all_organization_units_tl hr, pa_implementations pi

150:
151: BEGIN
152: select substr(hr.name,1,60)
153: into v_ou_name
154: from hr_all_organization_units_tl hr, pa_implementations pi
155: where hr.organization_id(+) = pi.org_id and
156: decode(hr.organization_id,null,'1',hr.language)=
157: decode(hr.organization_id,null,'1',userenv('lang'));
158: