Line 675: CURSOR cc is SELECT DATE_PLACED_IN_SERVICE FROM FA_BOOKS
671:
672: function get_date_place_in_service(p_asset_id in number) return varchar2
673: IS
674: lv_object_name CONSTANT VARCHAR2(61):= 'jai_fa_assets_pkg.get_date_place_in_service'; 675: CURSOR cc is SELECT DATE_PLACED_IN_SERVICE FROM FA_BOOKS 676: WHERE ASSET_ID =p_ASSET_ID;
677: da date;
678: begin
679: OPEN cc;