DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_ADDITIONS

Line 278: fa_additions ad ,

274: fa_calendar_periods cp ,
275: fa_deprn_periods dp ,
276: fa_transaction_headers th ,
277: fa_asset_history ah ,
278: fa_additions ad ,
279: fa_book_controls bc
280: WHERE ah.asset_id = ad.asset_id
281: AND fb.book_type_code = bc.book_type_code
282: AND fb.asset_id = ad.asset_id

Line 306: fa_additions ad ,

302: fa_calendar_periods cp ,
303: fa_deprn_periods_mrc_v dp ,
304: fa_transaction_headers th ,
305: fa_asset_history ah ,
306: fa_additions ad ,
307: fa_book_controls_mrc_v bc
308: WHERE ah.asset_id = ad.asset_id
309: AND fb.book_type_code = bc.book_type_code
310: AND fb.asset_id = ad.asset_id

Line 334: fa_additions ad ,

330: fa_calendar_periods cp ,
331: fa_deprn_periods dp ,
332: fa_transaction_headers th ,
333: fa_asset_history ah ,
334: fa_additions ad ,
335: fa_book_controls bc
336: WHERE ah.asset_id = ad.asset_id
337: AND fb.book_type_code = bc.book_type_code
338: AND fb.asset_id = ad.asset_id

Line 379: p_asset_desc fa_additions.description%TYPE;

375: +=========================================================================+*/
376: FUNCTION asset_desc (p_asset_number IN VARCHAR2)
377: RETURN VARCHAR2 IS
378:
379: p_asset_desc fa_additions.description%TYPE;
380:
381: BEGIN
382:
383: BEGIN

Line 390: FROM fa_additions faa

386: -- given asset. --
387: ------------------------------------------------------------
388: SELECT faa.description
389: INTO p_asset_desc
390: FROM fa_additions faa
391: WHERE faa.asset_number = p_asset_number;
392: END;
393:
394: RETURN (p_asset_desc);