DBA Data[Home] [Help]

APPS.PA_FAXFACE_RET_PVT dependencies on PA_PROJECT_ASSET_LINES

Line 21: pa_project_asset_lines pal

17: pal.cip_ccid rwip_ccid,
18: pal.current_asset_cost rwip_amount,
19: pal.retirement_cost_type
20: FROM pa_project_assets ppa,
21: pa_project_asset_lines pal
22: WHERE ppa.project_asset_id = pal.project_asset_id
23: AND pal.project_asset_line_id = x_project_asset_line_id;
24:
25: ret_adj_target_rec ret_adj_target_cur%ROWTYPE;

Line 136: UPDATE pa_project_asset_lines

132: AND v_trans_rec.who_info.last_update_date --Transaction date_effective as per BRIDGWAY
133: BETWEEN period_open_date AND NVL(period_close_date, SYSDATE);
134:
135: --Update project asset line with FA Period Posted and Txn ID
136: UPDATE pa_project_asset_lines
137: SET fa_period_name = v_fa_period_posted,
138: ret_adjustment_txn_id = v_trans_rec.transaction_header_id,
139: last_update_date = SYSDATE,
140: last_updated_by = v_user,