DBA Data[Home] [Help]

APPS.HR_REPORTS dependencies on PER_ORGANIZATION_STRUCTURES

Line 708: from per_organization_structures ost

704: begin
705: hr_utility.set_location('hr_reports.get_organization_hierarchy',10);
706: select ost.name
707: into p_org_structure_name
708: from per_organization_structures ost
709: where ost.organization_structure_id = p_organization_structure_id;
710: exception
711: when no_data_found then null;
712: end;

Line 724: from per_organization_structures ost,

720: into p_org_structure_name,
721: p_org_version,
722: p_version_start_date,
723: p_version_end_date
724: from per_organization_structures ost,
725: per_org_structure_versions osv
726: where osv.org_structure_version_id = p_org_structure_version_id
727: and ost.organization_structure_id = osv.organization_structure_id;
728: exception