APPS.PA_FA_TIEBACK_PVT dependencies on FA_DEPRN_PERIODS

Line 23: FROM fa_deprn_periods fdp,

19:
20:
21: CURSOR earliest_asset_period_cur(x_project_asset_id NUMBER) IS
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

Line 57: FROM fa_deprn_periods fdp,

53:
54: CURSOR asset_line_period_cur(x_project_asset_line_id NUMBER) IS
55: SELECT fdp.period_name,
56: SUM(payables_cost) payables_cost
57: FROM fa_deprn_periods fdp,
58: fa_asset_invoices fai,
59: fa_invoice_transactions fit
60: WHERE fai.project_asset_line_id = x_project_asset_line_id
61: AND fai.invoice_transaction_id_in = fit.invoice_transaction_id

Line 93: v_fa_period_name fa_deprn_periods.period_name%TYPE;

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');
97: