[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ppa.project_asset_id,
ppa.book_type_code,
ppa.ret_target_asset_id,
ppa.fa_period_name,
pal.cip_ccid rwip_ccid,
pal.current_asset_cost rwip_amount,
pal.retirement_cost_type
FROM pa_project_assets ppa,
pa_project_asset_lines pal
WHERE ppa.project_asset_id = pal.project_asset_id
AND pal.project_asset_line_id = x_project_asset_line_id;
SELECT fb.set_of_books_id
INTO v_set_of_books_id
FROM fa_book_controls fb,
pa_implementations pi
WHERE fb.set_of_books_id = pi.set_of_books_id
AND fb.book_type_code = ret_adj_target_rec.book_type_code;
SELECT period_name
INTO v_fa_period_posted
FROM fa_deprn_periods
WHERE book_type_code = v_asset_hdr_rec.book_type_code
AND v_trans_rec.who_info.last_update_date --Transaction date_effective as per BRIDGWAY
BETWEEN period_open_date AND NVL(period_close_date, SYSDATE);
UPDATE pa_project_asset_lines
SET fa_period_name = v_fa_period_posted,
ret_adjustment_txn_id = v_trans_rec.transaction_header_id,
last_update_date = SYSDATE,
last_updated_by = v_user,
last_update_login = v_login,
request_id = v_request_id,
program_application_id = v_program_application_id,
program_id = v_program_id,
program_update_date = SYSDATE
WHERE project_asset_line_id = x_project_asset_line_id;
UPDATE pa_project_assets
SET fa_period_name = v_fa_period_posted,
last_update_date = SYSDATE,
last_updated_by = v_user,
last_update_login = v_login,
request_id = v_request_id,
program_application_id = v_program_application_id,
program_id = v_program_id,
program_update_date = SYSDATE
WHERE project_asset_id = ret_adj_target_rec.project_asset_id;