165: IS
166: SELECT fdh.units_assigned
167: , papf.full_name
168: , papf.employee_number
169: FROM fa_distribution_history fdh
170: , per_all_people_f papf
171: , fa_book_controls fbc
172: WHERE fbc.book_type_code = p_book_type_code
173: AND fdh.book_type_code = fbc.distribution_source_book
879: ,fa_calendar_periods cp
880: , fa_fiscal_year fy
881: , fa_calendar_types fct
882: , fa_additions fa
883: , fa_distribution_history fdh
884: , fa_locations_kfv flk
885: , gl_code_combinations_kfv gcck
886: WHERE fa.asset_id = fb.asset_id
887: AND fb.asset_id = p_asset_id
1482: , fb.allowed_deprn_limit_amount
1483: FROM fa_books fb
1484: , fa_book_controls fbc -- As per Bug No .7183390 (For Tax Books)
1485: , fa_additions fa
1486: , fa_distribution_history fdh
1487: , fa_locations_kfv flk
1488: , gl_code_combinations_kfv gcck
1489: WHERE fa.asset_id = fb.asset_id
1490: AND fb.asset_id = p_asset_id