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_PGN_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 587: , p_business_group_id in hr_all_organization_units.business_group_id%TYPE

583: -- |---------------------------< chk_entity_id >------------------------------|
584: -- ----------------------------------------------------------------------------
585: Procedure chk_entity_id
586: ( p_entity_id in per_gen_hierarchy_nodes.entity_id%TYPE
587: , p_business_group_id in hr_all_organization_units.business_group_id%TYPE
588: , p_node_type in per_gen_hierarchy_nodes.node_type%TYPE
589: , p_hierarchy_version_id in per_gen_hierarchy_versions.hierarchy_version_id%TYPE
590: ) IS
591: --

Line 596: from hr_all_organization_units hou

592: l_ent_exists varchar2(1) := 'Y';
593: --
594: cursor csr_org_exists is
595: select 'Y'
596: from hr_all_organization_units hou
597: , hr_organization_information hoi
598: , per_gen_hierarchy_versions pgv
599: where hou.organization_id = p_entity_id
600: and (hou.business_group_id = p_business_group_id or p_business_group_id is null)