APPS.JTF_DIAGNOSTIC_COREAPI dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3839: l_org_name hr_all_organization_units.name%type;

3835: l_instance_name varchar2(16) := null;
3836: l_host_name varchar2(64) := null;
3837: l_language varchar2(512):= null;
3838: l_version varchar2(17) := null;
3839: l_org_name hr_all_organization_units.name%type;
3840: begin
3841: select instance_name, host_name, version
3842: into l_instance_name, l_host_name, l_version
3843: from v$instance;

Line 3861: from hr_all_organization_units

3857: line_out('Apps Version: '|| Get_DB_Apps_Version);
3858: if g_org_id is not null then
3859: begin
3860: select name into l_org_name
3861: from hr_all_organization_units
3862: where organization_id = g_org_id;
3863: exception when others then
3864: l_org_name := null;
3865: end;