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_ENT_BUS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 373: from PER_ORG_STRUCTURE_VERSIONS

369: --Declare the cursors
370:
371: cursor csr_org_hier(p_org_structure_version_id NUMBER) is
372: select date_from,date_to
373: from PER_ORG_STRUCTURE_VERSIONS
374: where org_structure_version_id = p_org_structure_version_id;
375:
376: cursor csr_geo_hier(p_hierarchy_id NUMBER) is
377: select date_from, date_to

Line 571: FROM per_org_structure_versions osv

567: -- if entry is global then Org Structure must also be global
568: -- if entry not global then Org Structure must be global or in the current business group
569: CURSOR CSR_ORG_HIER IS
570: SELECT 'Y'
571: FROM per_org_structure_versions osv
572: WHERE OSV.ORGANIZATION_STRUCTURE_ID = p_organization_structure_id
573: AND OSV.ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id
574: AND ( (p_business_group_id is not null and
575: (osv.business_group_id = p_business_group_id or osv.business_group_id is null))