DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_ASSET_HIERARCHY

Line 859: from fa_asset_hierarchy

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

Line 924: from fa_asset_hierarchy

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