APPS.PER_WORK_STRUCTURE_OVERRIDE_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 104: FROM hr_all_organization_units o, hr_organization_information oi

100: job_cursor cur_typ;
101:
102: CURSOR c_organizations IS
103: SELECT nvl(upper(replace(oi.org_information1,'|','||''.''||')),'j.name') slist
104: FROM hr_all_organization_units o, hr_organization_information oi
105: WHERE o.organization_id = p_bg_id
106: AND o.organization_id = oi.organization_id(+)
107: AND oi.org_information_context(+) = 'SSHR Information';
108: BEGIN