APPS.JL_CO_FA_PURGE_PKG dependencies on FA_DEPRN_PERIODS

Line 70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;

66: x_initial_period_counter fa_book_controls.initial_period_counter%TYPE;
67: x_current_fiscal_year fa_book_controls.current_fiscal_year%TYPE;
68: x_deprn_status fa_book_controls.deprn_status%TYPE;
69: x_book_class fa_book_controls.book_class%TYPE;
70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
71: x_count NUMBER;
72: x_index NUMBER(7);
73: x_period_number fa_calendar_types.number_per_fiscal_year%TYPE;
74: x_start_period_counter fa_deprn_periods.period_counter%TYPE;

Line 74: x_start_period_counter fa_deprn_periods.period_counter%TYPE;

70: x_initial_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
71: x_count NUMBER;
72: x_index NUMBER(7);
73: x_period_number fa_calendar_types.number_per_fiscal_year%TYPE;
74: x_start_period_counter fa_deprn_periods.period_counter%TYPE;
75: x_end_period_counter fa_deprn_periods.period_counter%TYPE;
76: x_adjustments_rows NUMBER(15);
77: x_adj_table VARCHAR2(30);
78: x_oracle_username VARCHAR2(30);

Line 75: x_end_period_counter fa_deprn_periods.period_counter%TYPE;

71: x_count NUMBER;
72: x_index NUMBER(7);
73: x_period_number fa_calendar_types.number_per_fiscal_year%TYPE;
74: x_start_period_counter fa_deprn_periods.period_counter%TYPE;
75: x_end_period_counter fa_deprn_periods.period_counter%TYPE;
76: x_adjustments_rows NUMBER(15);
77: x_adj_table VARCHAR2(30);
78: x_oracle_username VARCHAR2(30);
79: x_adjustments_amount NUMBER;

Line 175: FROM fa_deprn_periods

171: ---------------------------------------------------------
172:
173: SELECT fiscal_year
174: INTO x_initial_fiscal_year
175: FROM fa_deprn_periods
176: WHERE book_type_code = p_book
177: AND period_counter = x_initial_period_counter;
178:
179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 451: FROM fa_deprn_periods

447: WHERE calendar_type = x_deprn_calendar;
448:
449: SELECT period_counter
450: INTO x_start_period_counter
451: FROM fa_deprn_periods
452: WHERE book_type_code = p_book
453: AND fiscal_year = p_fiscal_year
454: AND period_num = 1;
455:

Line 462: FROM fa_deprn_periods

458: SELECT MIN(period_counter),
459: MAX(period_counter)
460: INTO x_start_period_counter,
461: x_end_period_counter
462: FROM fa_deprn_periods
463: WHERE book_type_code = p_book
464: AND fiscal_year = p_fiscal_year;
465:
466: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN