APPS.JTF_DIAGNOSTIC_COREAPI dependencies on HR_ALL_ORGANIZATION_UNITS

Line 3835: l_org_name hr_all_organization_units.name%type;

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

Line 3857: from hr_all_organization_units

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