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 1414: 'FROM hr_all_organization_units hou, hr_all_organization_units_tl houtl ,'||

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

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

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

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

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