APPS.PA_FA_TIEBACK_PVT dependencies on PA_PROJECT_ASSETS

Line 13: FROM pa_project_assets pa

9:
10: CURSOR project_assets_cur IS
11: SELECT pa.project_asset_id,
12: pa.asset_number
13: FROM pa_project_assets pa
14: WHERE pa.project_asset_type = 'AS-BUILT'
15: AND pa.capitalized_flag = 'Y'
16: AND pa.fa_period_name IS NULL;
17:

Line 43: FROM pa_project_assets pa,

39:
40: CURSOR asset_lines_cur IS
41: SELECT pal.project_asset_line_id,
42: pal.current_asset_cost
43: FROM pa_project_assets pa,
44: pa_project_asset_lines_all pal
45: WHERE pa.project_asset_id = pal.project_asset_id
46: AND pa.project_asset_type = 'AS-BUILT'
47: AND pal.transfer_status_code = 'T'

Line 188: UPDATE pa_project_assets_all

184: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Tieback project asset with asset number, fa_asset_id and fa period');
185: END IF;
186:
187: --Update project asset with asset number and FA period name
188: UPDATE pa_project_assets_all
189: SET asset_number = v_asset_number,
190: fa_asset_id = v_asset_id,
191: fa_period_name = v_fa_period_name,
192: last_update_date = SYSDATE,

Line 209: UPDATE pa_project_assets_all

205: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Tieback project asset with fa_asset_id and fa period');
206: END IF;
207:
208: --Just update the FA Period Name and FA Asset ID
209: UPDATE pa_project_assets_all
210: SET fa_period_name = v_fa_period_name,
211: fa_asset_id = v_asset_id,
212: last_update_date = SYSDATE,
213: last_updated_by = v_user,