DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on FA_ADDITIONS

Line 441: fa_additions_b fa

437: CURSOR prorate_convention_cur ( c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS
438: SELECT fcgd.retirement_prorate_convention
439: FROM fa_category_book_defaults fcgd,
440: fa_books fb,
441: fa_additions_b fa
442: WHERE fa.asset_id = c_asset_id
443: AND fb.asset_id = fa.asset_id
444: AND fb.book_type_code = c_book_type_code
445: AND fb.date_ineffective IS NULL

Line 567: fa_additions fa,

563: cia.asset_quantity instance_asset_qty,
564: cia.instance_asset_id
565: FROM fa_distribution_history fdh,
566: csi_i_assets cia,
567: fa_additions fa,
568: fa_books fb,
569: csi_item_instances cii
570: WHERE cii.instance_id = c_instance_id
571: AND cia.instance_id = cii.instance_id