APPS.PER_EMPDIR_SS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 13: FROM hr_all_organization_units o, hr_organization_information oi

9: g_schema_owner VARCHAR2(30);
10:
11: CURSOR c_organizations IS
12: SELECT o.organization_id, nvl(upper(replace(oi.org_information1,'|','||''.''||')),'j.name') slist
13: FROM hr_all_organization_units o, hr_organization_information oi
14: WHERE o.organization_id = o.business_group_id
15: AND o.organization_id = oi.organization_id (+)
16: AND oi.org_information_context(+) = 'SSHR Information';
17:

Line 1410: 'FROM hr_all_organization_units hou, hr_all_organization_units_tl houtl ,'||

1406: 'hou.attribute2, hou.attribute3, hou.attribute4, hou.attribute5, hou.attribute6,'||
1407: 'hou.attribute7, hou.attribute8, hou.attribute9, hou.attribute10, hou.attribute11,'||
1408: 'hou.attribute12, hou.attribute13,hou.attribute14, hou.attribute15, hou.attribute16,'||
1409: 'hou.attribute17, hou.attribute18, hou.attribute19, hou.attribute20 '||
1410: 'FROM hr_all_organization_units hou, hr_all_organization_units_tl houtl ,'||
1411: 'hr_organization_information oi '||
1412: 'WHERE hou.organization_id = houtl.organization_id'||
1413: ' AND hou.business_group_id = oi.organization_id'||
1414: ' AND oi.org_information_context = ''Business Group Information'''||

Line 1417: ' (SELECT organization_id FROM hr_all_organization_units ihou'||

1413: ' AND hou.business_group_id = oi.organization_id'||
1414: ' AND oi.org_information_context = ''Business Group Information'''||
1415: ' /* Avoiding PK Violation */'||
1416: ' AND houtl.organization_id NOT IN '||
1417: ' (SELECT organization_id FROM hr_all_organization_units ihou'||
1418: ' GROUP BY organization_id HAVING count(*) > 1)';
1419: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
1420: query_str := query_str || ' AND houtl.organization_id NOT IN '||
1421: ' (SELECT organization_id FROM hr_all_organization_units lhou'||

Line 1421: ' (SELECT organization_id FROM hr_all_organization_units lhou'||

1417: ' (SELECT organization_id FROM hr_all_organization_units ihou'||
1418: ' GROUP BY organization_id HAVING count(*) > 1)';
1419: IF hr_multi_tenancy_pkg.get_system_model = 'B' THEN
1420: query_str := query_str || ' AND houtl.organization_id NOT IN '||
1421: ' (SELECT organization_id FROM hr_all_organization_units lhou'||
1422: ' WHERE label_to_char(lhou.HR_ENTERPRISE) = ''C::ENT'' OR label_to_char(lhou.HR_ENTERPRISE) is null)';
1423: END IF;
1424: IF (p_mode = 0) THEN
1425: OPEN p_cursor FOR query_str;