APPS.IGI_IAC_WEBADI_PKG dependencies on FA_DEPRN_SUMMARY

Line 270: l_dpis_period_counter fa_deprn_summary.period_counter%type;

266: and date_ineffective is null;
267:
268: l_date_placed_in_service fa_books.date_placed_in_service%type;
269: l_life_in_months fa_books.life_in_months%type;
270: l_dpis_period_counter fa_deprn_summary.period_counter%type;
271: l_end_date fa_books.date_placed_in_service%type;
272: l_end_period_counter fa_deprn_summary.period_counter%type;
273: l_total_periods number;
274: l_remaining_periods number;

Line 272: l_end_period_counter fa_deprn_summary.period_counter%type;

268: l_date_placed_in_service fa_books.date_placed_in_service%type;
269: l_life_in_months fa_books.life_in_months%type;
270: l_dpis_period_counter fa_deprn_summary.period_counter%type;
271: l_end_date fa_books.date_placed_in_service%type;
272: l_end_period_counter fa_deprn_summary.period_counter%type;
273: l_total_periods number;
274: l_remaining_periods number;
275: Begin
276: Open C_Dpis(p_upload_record.book_type_code, p_upload_record.asset_id);

Line 330: l_dpis_period_counter fa_deprn_summary.period_counter%type;

326: and date_ineffective is null;
327:
328: l_date_placed_in_service fa_books.date_placed_in_service%type;
329: l_life_in_months fa_books.life_in_months%type;
330: l_dpis_period_counter fa_deprn_summary.period_counter%type;
331: l_end_date fa_books.date_placed_in_service%type;
332: l_end_period_counter fa_deprn_summary.period_counter%type;
333: l_total_periods number;
334: l_remaining_periods number;

Line 332: l_end_period_counter fa_deprn_summary.period_counter%type;

328: l_date_placed_in_service fa_books.date_placed_in_service%type;
329: l_life_in_months fa_books.life_in_months%type;
330: l_dpis_period_counter fa_deprn_summary.period_counter%type;
331: l_end_date fa_books.date_placed_in_service%type;
332: l_end_period_counter fa_deprn_summary.period_counter%type;
333: l_total_periods number;
334: l_remaining_periods number;
335: Begin
336: Open C_Dpis(p_book_type_code, p_asset_id);

Line 451: From fa_deprn_summary

447:
448: Cursor C_Max_Period_counter(
449: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
450: Select max(period_counter)
451: From fa_deprn_summary
452: Where book_type_code = cp_book_type_code;
453:
454: Cursor C_Last_Closed_Period(
455: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is

Line 1189: From fa_deprn_summary

1185:
1186: Cursor C_Max_Period_counter(
1187: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is
1188: Select max(period_counter) max_period_counter
1189: From fa_deprn_summary
1190: Where book_type_code = cp_book_type_code;
1191:
1192: Cursor C_Last_Closed_Period(
1193: cp_book_type_code in igi_iac_upload_headers.book_type_code%type) Is