APPS.PA_FA_TIEBACK_PVT dependencies on PA_PROJECT_ASSET_LINES_ALL

Line 26: pa_project_asset_lines_all pal

22: SELECT fdp.period_name, MIN(fit.date_effective)
23: FROM fa_deprn_periods fdp,
24: fa_asset_invoices fai,
25: fa_invoice_transactions fit,
26: pa_project_asset_lines_all pal
27: WHERE fai.project_asset_line_id = pal.project_asset_line_id
28: AND pal.project_asset_id = x_project_asset_id
29: AND fai.invoice_transaction_id_in = fit.invoice_transaction_id
30: AND fit.transaction_type = 'MASS ADDITION'

Line 44: pa_project_asset_lines_all pal

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'
48: AND pal.line_type = 'C'

Line 75: pa_project_asset_lines_all pal

71: CURSOR fa_assets_cur(x_project_asset_id NUMBER) IS
72: SELECT fa.asset_id, fa.asset_number
73: FROM fa_additions fa,
74: fa_asset_invoices fai,
75: pa_project_asset_lines_all pal
76: WHERE fai.project_asset_line_id = pal.project_asset_line_id
77: AND pal.project_asset_id = x_project_asset_id
78: AND fai.asset_id = fa.asset_id
79: GROUP BY fa.asset_id, fa.asset_number;

Line 266: UPDATE pa_project_asset_lines_all

262: PA_DEBUG.WRITE_FILE('LOG',TO_CHAR(SYSDATE,'HH:MI:SS')||': '||'Tieback project asset line with fa period: '||asset_line_period_rec.period_name);
263: END IF;
264:
265: --Update asset line with FA Period Name
266: UPDATE pa_project_asset_lines_all
267: SET fa_period_name = asset_line_period_rec.period_name,
268: last_update_date = SYSDATE,
269: last_updated_by = v_user,
270: last_update_login = v_login,