APPS.PA_PAXEXCPD_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 177: from hr_all_organization_units_tl hr,

173: BEGIN
174:
175: select hr.name
176: into v_ou_name
177: from hr_all_organization_units_tl hr,
178: pa_implementations pi
179: where hr.organization_id(+) = pi.org_id
180: and decode(hr.organization_id,null,'1',hr.language)=
181: decode(hr.organization_id,null,'1',userenv('lang')) ;

Line 260: from hr_all_organization_units_tl hr,

256: BEGIN
257:
258: select hr.name
259: into v_ou_name
260: from hr_all_organization_units_tl hr,
261: pa_implementations pi
262: where hr.organization_id(+) = pi.org_id
263: and decode(hr.organization_id,null,'1',hr.language)=
264: decode(hr.organization_id,null,'1',userenv('lang')) ;