[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fmr.mass_retirement_id,
fmr.reinstate_request_id,
fmr.retire_request_id,
fmr.book_type_code,
ffy.start_date,
ffy.end_date
FROM fa_mass_retirements fmr,
fa_book_controls fbc,
fa_fiscal_year ffy
WHERE fmr.mass_retirement_id = p_Mass_Retirement_Id
AND fmr.book_type_code = fbc.book_type_code
AND ffy.fiscal_year_name = fbc.fiscal_year_name
AND ffy.fiscal_year = fbc.current_fiscal_year ;
SELECT th.asset_id,
ad.asset_number,
ret.status,
ret.retirement_id
FROM fa_retirements ret,
fa_transaction_headers th,
fa_additions_b ad,
fa_books bk
WHERE th.mass_transaction_id = l_mass_retirement_id
AND th.book_type_code = l_Book_Type_Code
AND th.transaction_type_code in ('FULL RETIREMENT','PARTIAL RETIREMENT') -- df. this change makes partial unit retirements to be mass reinstated.
AND th.transaction_key = 'R'
AND ret.book_type_code = th.book_type_code
AND ret.asset_id = th.asset_id
AND ret.transaction_header_id_in = th.transaction_header_id
AND ret.transaction_header_id_out IS NULL
AND ret.date_retired BETWEEN l_FY_Start_Date
AND l_FY_End_Date
AND ret.asset_id > px_max_asset_id
AND ret.asset_id = ad.asset_id
AND ret.asset_id = bk.asset_id
AND ret.book_type_code = bk.book_type_code
AND bk.date_ineffective is null
AND MOD(nvl(bk.group_asset_id,
ret.asset_id),
p_total_requests) = (p_request_number - 1)
ORDER BY ret.retirement_id;
l_trans_rec.who_info.last_update_date := sysdate;