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_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_HIERARCHY_DENORM

Line 310: FROM pa_org_hierarchy_denorm

306: null. p_budget_version_id will only be passed from the OA pages */
307:
308: CURSOR org_hierarchy is
309: SELECT child_organization_id
310: FROM pa_org_hierarchy_denorm
311: WHERE pa_org_use_type = 'REPORTING'
312: and parent_organization_id = p_starting_organization_id
313: and org_id = l_org_id
314: and org_hierarchy_version_id = l_org_structure_version_id

Line 345: FROM pa_org_hierarchy_denorm pa

341: AND houtl.language = USERENV('LANG');
342:
343: CURSOR sub_orgs IS
344: SELECT pa.child_organization_id
345: FROM pa_org_hierarchy_denorm pa
346: WHERE pa.pa_org_use_type = 'REPORTING'
347: AND pa.parent_level-pa.child_level < 1
348: AND nvl(pa.org_id,-99) = l_org_id
349: AND pa.org_hierarchy_version_id = l_org_structure_version_id