DBA Data[Home] [Help]

APPS.FA_CUA_HR_RETIREMENTS_PKG dependencies on FA_BOOKS

Line 865: , fa_books fab

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

Line 894: fa_books fb

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

Line 930: , fa_books fab

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

Line 959: fa_books fb

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