DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_ASSET_HIERARCHY

Line 863: from fa_asset_hierarchy

859: CURSOR C_get_totals IS
860: select sum(fab.cost) total_cost
861: , sum(fah.units) total_units
862: from ( select asset_id
863: from fa_asset_hierarchy
864: where asset_id IS NOT NULL
865: start with asset_hierarchy_id = x_node_entity_id
866: connect by prior asset_hierarchy_id = parent_hierarchy_id ) hr
867: , fa_asset_history fah

Line 928: from fa_asset_hierarchy

924: , fah.units
925: , fab.itc_amount
926: , fab.itc_amount_id
927: from ( select asset_id
928: from fa_asset_hierarchy
929: where asset_id IS NOT NULL
930: start with asset_hierarchy_id = x_node_entity_id
931: connect by prior asset_hierarchy_id = parent_hierarchy_id ) hr
932: , fa_asset_history fah