DBA Data[Home] [Help]

APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on FA_RETIREMENTS

Line 536: fa_retirements a

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
538: AND a.transaction_header_id_in = b.transaction_header_id
539: AND b.transaction_date_entered BETWEEN g_current_period_from_date1
540: AND g_current_period_to_date1

Line 739: fa_retirements a

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
741: AND a.transaction_header_id_out = b.transaction_header_id
742: AND b.transaction_type_code = 'REINSTATEMENT'
743: AND b.transaction_date_entered BETWEEN g_current_period_from_date1