APPS.PA_FAXFACE_RET_PVT dependencies on PA_PROJECT_ASSETS

Line 20: FROM pa_project_assets ppa,

16: ppa.fa_period_name,
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:

Line 34: v_fa_period_posted PA_PROJECT_ASSETS_ALL.fa_period_name%TYPE;

30: v_request_id NUMBER := FND_GLOBAL.conc_request_id;
31: v_program_application_id NUMBER := FND_GLOBAL.prog_appl_id;
32: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
33:
34: v_fa_period_posted PA_PROJECT_ASSETS_ALL.fa_period_name%TYPE;
35: v_set_of_books_id NUMBER;
36: v_proceeds NUMBER := 0;
37: v_proceeds_ccid NUMBER := NULL;
38: v_cost_of_removal NUMBER := 0;

Line 151: UPDATE pa_project_assets

147:
148: --Update project asset with FA Period Posted, if field is currently NULL (first line posted for asset)
149: IF ret_adj_target_rec.fa_period_name IS NULL THEN
150:
151: UPDATE pa_project_assets
152: SET fa_period_name = v_fa_period_posted,
153: last_update_date = SYSDATE,
154: last_updated_by = v_user,
155: last_update_login = v_login,