APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on FA_BOOKS

Line 533: FROM fa_books d,

529: CURSOR fa_ret IS
530: SELECT a.retirement_id,a.asset_id asset_id,
531: b.transaction_header_id transaction_header_id,
532: rpad(c.asset_number||'-'||substr(c.description,1,30),45,' ') asset_desc
533: FROM fa_books d,
534: fa_additions c,
535: fa_transaction_headers b,
536: fa_retirements a
537: WHERE a.book_type_code = p_book_type_code

Line 736: FROM fa_books d,

732: CURSOR fa_ret IS
733: SELECT a.retirement_id retirement_id,a.asset_id asset_id,
734: b.transaction_header_id transaction_header_id,
735: rpad(c.asset_number||'-'||substr(c.description,1,30),45,' ') asset_desc
736: FROM fa_books d,
737: fa_additions c,
738: fa_transaction_headers b,
739: fa_retirements a
740: WHERE a.book_type_code = p_book_type_code

Line 1015: FROM fa_books b

1011: END IF;
1012:
1013: SELECT b.date_placed_in_service
1014: INTO cur_date_placed_in_service
1015: FROM fa_books b
1016: WHERE b.book_type_code = p_book_type_code
1017: AND b.asset_id = fa_adjst_rec.asset_id
1018: AND b.retirement_id = fa_adjst_rec.retirement_id;
1019: