278: -- Assign From Clause
279: --
280: FA_RX_UTIL_PKG.From_Clause :=
281: 'fa_books BO,
282: fa_additions AD,
283: fa_categories CA,
284: fa_category_books CB,
285: fa_methods METH';
286:
586: -- Assign From Clause
587: --
588: FA_RX_UTIL_PKG.From_Clause :=
589: 'fa_retirements re,
590: fa_additions ad,
591: fa_categories ca,
592: fa_books bo,
593: fa_methods METH';
594:
1310: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_parent_asset_number()+');
1311:
1312: SELECT asset_number
1313: INTO X_parent_asset_number
1314: FROM fa_additions
1315: WHERE asset_id = JG_RX_FAREG.var.parent_asset_id;
1316:
1317: FA_RX_UTIL_PKG.debug('JG_RX_FAREG.Get_parent_asset_number()-');
1318: