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 2156: from pa_org_hierarchy_denorm org,

2152: IS
2153: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
2154: /* CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2155: select org.child_organization_id c_org
2156: from pa_org_hierarchy_denorm org,
2157: pa_implementations imp
2158: where org.parent_organization_id = p_org_id
2159: and org.parent_level - org.child_level = 1
2160: and org.pa_org_use_type = 'REPORTING'

Line 2168: from pa_org_hierarchy_denorm org,

2164: nvl(to_number(decode(substr(userenv('client_info'),1,1),' ',null,substr(userenv('client_info'),1,10))),-99)
2165: order by org.child_organization_id; */
2166: CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2167: select org.child_organization_id c_org
2168: from pa_org_hierarchy_denorm org,
2169: pa_implementations imp
2170: where org.parent_organization_id = p_org_id
2171: and org.parent_level - org.child_level = 1
2172: and org.pa_org_use_type = 'REPORTING'