DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_ADDITIONS

Line 159: from fa_additions

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

Line 866: , fa_additions faa

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

Line 931: , fa_additions faa

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