APPS.PA_FA_TIEBACK_PVT dependencies on FA_ADDITIONS

Line 73: FROM fa_additions fa,

69:
70:
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

Line 91: v_asset_number fa_additions.asset_number%TYPE;

87: v_program_id NUMBER := FND_GLOBAL.conc_program_id;
88:
89: v_asset_count NUMBER := 0;
90: v_asset_number_count NUMBER := 0;
91: v_asset_number fa_additions.asset_number%TYPE;
92: v_asset_id fa_additions.asset_id%TYPE;
93: v_fa_period_name fa_deprn_periods.period_name%TYPE;
94: v_asset_line_count NUMBER := 0;
95:

Line 92: v_asset_id fa_additions.asset_id%TYPE;

88:
89: v_asset_count NUMBER := 0;
90: v_asset_number_count NUMBER := 0;
91: v_asset_number fa_additions.asset_number%TYPE;
92: v_asset_id fa_additions.asset_id%TYPE;
93: v_fa_period_name fa_deprn_periods.period_name%TYPE;
94: v_asset_line_count NUMBER := 0;
95:
96: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');