APPS.PA_SUMMARIZE_ORG_ROLLUP_PVT dependencies on PA_ORG_HIERARCHY_DENORM

Line 144: FROM pa_org_hierarchy_denorm

140: * Determining the maximum level in the hierarchy for rollup.
141: */
142: SELECT parent_level
143: INTO l_maximum_level
144: FROM pa_org_hierarchy_denorm
145: WHERE parent_organization_id = l_start_org_id
146: AND pa_org_use_type = 'REPORTING'
147: AND ORG_HIERARCHY_VERSION_ID = l_org_structure_version_id
148: AND NVL(org_id, -99) = l_org_id

Line 282: ,pa_org_hierarchy_denorm hier

278: ,obj.org_util_category_id
279: ,obj.work_type_id
280: ,hier.parent_organization_id
281: FROM pa_objects obj
282: ,pa_org_hierarchy_denorm hier
283: WHERE hier.child_organization_id = obj.expenditure_organization_id
284: AND hier.pa_org_use_type = 'REPORTING'
285: AND hier.ORG_HIERARCHY_VERSION_ID = l_org_structure_version_id
286: AND hier.parent_level = p_level

Line 480: FROM pa_org_hierarchy_denorm hier

476: ,bal.quarter_or_month_number
477: ,bal.amount_type_id
478: ,bal.period_num
479: ,bal.period_balance
480: FROM pa_org_hierarchy_denorm hier
481: ,pa_summ_balances bal
482: ,pa_objects obj
483: WHERE hier.parent_organization_id = p_start_org_id
484: AND hier.parent_level = p_maximum_level

Line 537: ,pa_org_hierarchy_denorm hier

533: ,SUM(bal.period_balance)
534: FROM pa_summ_balances bal
535: ,pa_objects obj
536: ,pa_objects obj1
537: ,pa_org_hierarchy_denorm hier
538: WHERE obj1.object_type_code = obj.object_type_code
539: AND obj1.balance_type_code = obj.balance_type_code
540: AND obj1.project_org_id = obj.project_org_id
541: AND obj1.project_organization_id = obj.project_organization_id

Line 1074: FROM pa_org_hierarchy_denorm hier

1070: ,bal.period_year
1071: ,bal.quarter_or_month_number
1072: ,bal.amount_type_id
1073: ,bal.period_balance
1074: FROM pa_org_hierarchy_denorm hier
1075: ,pa_summ_balances bal
1076: ,pa_objects obj
1077: WHERE hier.parent_organization_id = p_start_org_id
1078: AND hier.parent_level = p_maximum_level

Line 1130: ,pa_org_hierarchy_denorm hier

1126: ,SUM(bal.period_balance)
1127: FROM pa_summ_balances bal
1128: ,pa_objects obj
1129: ,pa_objects obj1
1130: ,pa_org_hierarchy_denorm hier
1131: WHERE obj1.object_type_code = obj.object_type_code
1132: AND obj1.balance_type_code = obj.balance_type_code
1133: AND obj1.project_org_id = obj.project_org_id
1134: AND obj1.project_organization_id = obj.project_organization_id