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.PA_RESOURCE_UTILS dependencies on PA_ORG_HIERARCHY_DENORM

Line 2039: from pa_org_hierarchy_denorm org,

2035: IS
2036: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
2037: /* CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2038: select org.child_organization_id c_org
2039: from pa_org_hierarchy_denorm org,
2040: pa_implementations imp
2041: where org.parent_organization_id = p_org_id
2042: and org.parent_level - org.child_level = 1
2043: and org.pa_org_use_type = 'REPORTING'

Line 2051: from pa_org_hierarchy_denorm org,

2047: nvl(to_number(decode(substr(userenv('client_info'),1,1),' ',null,substr(userenv('client_info'),1,10))),-99)
2048: order by org.child_organization_id; */
2049: CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2050: select org.child_organization_id c_org
2051: from pa_org_hierarchy_denorm org,
2052: pa_implementations imp
2053: where org.parent_organization_id = p_org_id
2054: and org.parent_level - org.child_level = 1
2055: and org.pa_org_use_type = 'REPORTING'