DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_ADDITIONS

Line 161: from fa_additions

157: event_code = 'CHANGE_NODE_PARENT')
158: )
159: OR ( event_code IN ( 'CHANGE_CATEGORY_LIFE', 'CHANGE_CATEGORY_LIFE_END_DATE') AND
160: to_number(a.source_entity_key_value) = (select asset_category_id
161: from fa_additions
162: where asset_id = x_asset_id )
163: )
164: )
165: );

Line 870: , fa_additions faa

866: connect by prior asset_hierarchy_id = parent_hierarchy_id ) hr
867: , fa_asset_history fah
868: , fa_category_book_defaults fcbd
869: , fa_books fab
870: , fa_additions faa
871: where hr.asset_id = faa.asset_id
872: AND faa.asset_id = fab.asset_id
873: AND fab.book_type_code = x_book_type_code
874: -- AND fab.cost > 0

Line 935: , fa_additions faa

931: connect by prior asset_hierarchy_id = parent_hierarchy_id ) hr
932: , fa_asset_history fah
933: , fa_category_book_defaults fcbd
934: , fa_books fab
935: , fa_additions faa
936: where hr.asset_id = faa.asset_id
937: AND faa.asset_id = fab.asset_id
938: AND fab.book_type_code = x_book_type_code
939: -- AND fab.cost > 0