eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_EMPDIR_SS dependencies on HR_ORGANIZATION_INFORMATION

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 460: 'FROM hr_all_positions_f p, hr_all_positions_f_tl ptl, hr_organization_information oi '||

456: 'information12, information13, information14, information15, information16, information17,'||
457: 'information18, information19, information20, information21, information22, information23,'||
458: 'information24, information25, information26, information27, information28, information29,'||
459: 'information30 '||
460: 'FROM hr_all_positions_f p, hr_all_positions_f_tl ptl, hr_organization_information oi '||
461: 'WHERE p.position_id = ptl.position_id'||
462: ' AND :1 between p.effective_start_date AND p.effective_end_date'||
463: ' AND p.business_group_id = oi.organization_id'||
464: ' AND oi.org_information_context = ''Business Group Information''';

Line 1101: ' ,hr_organization_information oi '||

1097: 'ass_attribute19, ass_attribute20, ass_attribute21, ass_attribute22, ass_attribute23,'||
1098: 'ass_attribute24, ass_attribute25, ass_attribute26, ass_attribute27, ass_attribute28,'||
1099: 'ass_attribute29, ass_attribute30 '||
1100: ' FROM per_assignments_f paf, per_assignment_status_types astatus' ||
1101: ' ,hr_organization_information oi '||
1102: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date'||
1103: ' AND paf.assignment_status_type_id = astatus.assignment_status_type_id'||
1104: ' AND paf.business_group_id = oi.organization_id'||
1105: ' AND oi.org_information_context = ''Business Group Information'''||

Line 1415: 'hr_organization_information oi '||

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'''||
1419: ' /* Avoiding PK Violation */'||

Line 1619: ',hr_organization_information oi '||

1615: 'job_information10, job_information11, job_information12, job_information13, '||
1616: 'job_information14, job_information15, job_information16, job_information17, '||
1617: 'job_information18, job_information19, job_information20 '||
1618: 'FROM per_jobs j, per_jobs_tl jtl, per_job_definitions jd '||
1619: ',hr_organization_information oi '||
1620: 'WHERE j.job_id = jtl.job_id '||
1621: 'AND j.job_definition_id = jd.job_definition_id '||
1622: 'AND jtl.name is not null '||
1623: 'AND j.business_group_id = :1 '||

Line 2183: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||

2179: 'per_information21, per_information22, per_information23, per_information24, per_information25,' ||
2180: 'per_information26, per_information27, per_information28, per_information29, per_information30' ||
2181: ',NULL directs' ||
2182: ',NULL total' ||
2183: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||
2184: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2185: ' AND (current_employee_flag = ''Y'' OR current_npw_flag = ''Y'')' ||
2186: ' AND ppf.business_group_id = oi.organization_id' ||
2187: ' AND oi.org_information_context = ''Business Group Information''' ||

Line 2278: ' ,hr_organization_information oi, per_empdir_people hrdp' ||

2274: 'ppf.per_information27, ppf.per_information28, ppf.per_information29, ppf.per_information30' ||
2275: ',hrdp.direct_reports' ||
2276: ',hrdp.total_reports ' ||
2277: ' FROM per_people_f ppf, per_phones ph' ||
2278: ' ,hr_organization_information oi, per_empdir_people hrdp' ||
2279: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2280: ' AND hrdp.orig_system = ''' || g_srcSystem || '''' ||
2281: ' AND ppf.person_id = hrdp.orig_system_id' ||
2282: ' AND (ppf.object_version_number <> hrdp.object_version_number OR' ||

Line 2368: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||

2364: 'per_information21, per_information22, per_information23, per_information24, per_information25,' ||
2365: 'per_information26, per_information27, per_information28, per_information29, per_information30' ||
2366: ',NULL directs' ||
2367: ',NULL total' ||
2368: ' FROM per_people_f ppf, per_phones ph, hr_organization_information oi' ||
2369: ' WHERE :1 BETWEEN effective_start_date AND effective_end_date' ||
2370: ' AND (current_employee_flag = ''Y'' OR current_npw_flag = ''Y'')' ||
2371: ' AND ppf.business_group_id = oi.organization_id' ||
2372: ' AND oi.org_information_context = ''Business Group Information''' ||