DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_BOOKS

Line 869: , fa_books fab

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
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

Line 898: fa_books fb

894: AND fad.code_combination_id = gcc.code_combination_id
895: AND fad.date_ineffective IS NULL )
896: AND NOT EXISTS ( select 'X' --'PROCESSED RETIREMENT'
897: from fa_retirements frt,
898: fa_books fb
899: where frt.asset_id = fab.asset_id
900: AND frt.asset_id = fb.asset_id
901: AND frt.transaction_header_id_out is NULL
902: AND frt.status = 'PROCESSED'

Line 934: , fa_books fab

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
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

Line 963: fa_books fb

959: AND fad.code_combination_id = gcc.code_combination_id
960: AND fad.date_ineffective IS NULL )
961: AND NOT EXISTS ( select 'X' --'PROCESSED RETIREMENT'
962: from fa_retirements frt,
963: fa_books fb
964: where frt.asset_id = fab.asset_id
965: AND frt.asset_id = fb.asset_id
966: AND frt.transaction_header_id_out is NULL
967: AND frt.status = 'PROCESSED'