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.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 1950: FROM per_org_structure_versions_v pos,

1946: -- If it is attached get the valid version as of the effective date.
1947: -- If a valid version is not found then do nothing.
1948: CURSOR c_get_org_hierarchy IS
1949: SELECT pos.org_structure_version_id
1950: FROM per_org_structure_versions_v pos,
1951: hr_organization_information hoi
1952: WHERE hoi.organization_id = p_business_group_id
1953: AND To_Number(hoi.org_information1) = pos.organization_structure_id
1954: AND Trunc(p_effective_date) BETWEEN date_from