APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 192: FROM FA_DEPRN_PERIODS_MRC_V fdp

188: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
189: AND ASSET_ID = p_asset_id_in
190: AND period_counter = p_period_counter
191: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
192: FROM FA_DEPRN_PERIODS_MRC_V fdp
193: WHERE FDP.book_type_code = P_BOOK_NAME
194: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
195: FROM FA_DEPRN_PERIODS_MRC_V
196: WHERE book_type_code = P_BOOK_NAME

Line 195: FROM FA_DEPRN_PERIODS_MRC_V

191: AND PERIOD_COUNTER > (SELECT MAX(fdp.period_counter)
192: FROM FA_DEPRN_PERIODS_MRC_V fdp
193: WHERE FDP.book_type_code = P_BOOK_NAME
194: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
195: FROM FA_DEPRN_PERIODS_MRC_V
196: WHERE book_type_code = P_BOOK_NAME
197: AND period_close_date IS NOT NULL));
198: ELSE
199:

Line 240: FROM FA_DEPRN_PERIODS_MRC_V fdp

236: FROM FA_DEPRN_SUMMARY_MRC_V
237: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
238: AND ASSET_ID = p_asset_id_in
239: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
240: FROM FA_DEPRN_PERIODS_MRC_V fdp
241: WHERE FDP.book_type_code = P_BOOK_NAME
242: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
243: FROM FA_DEPRN_PERIODS_MRC_V
244: WHERE book_type_code = P_BOOK_NAME

Line 243: FROM FA_DEPRN_PERIODS_MRC_V

239: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
240: FROM FA_DEPRN_PERIODS_MRC_V fdp
241: WHERE FDP.book_type_code = P_BOOK_NAME
242: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
243: FROM FA_DEPRN_PERIODS_MRC_V
244: WHERE book_type_code = P_BOOK_NAME
245: AND period_close_date IS NOT NULL));
246:
247: ELSE

Line 289: FROM FA_DEPRN_PERIODS_MRC_V fdp

285: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
286: AND ASSET_ID = p_asset_id_in
287: AND PERIOD_COUNTER = P_PERIOD_COUNTER
288: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
289: FROM FA_DEPRN_PERIODS_MRC_V fdp
290: WHERE FDP.book_type_code = P_BOOK_NAME
291: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
292: FROM FA_DEPRN_PERIODS_MRC_V
293: WHERE book_type_code = P_BOOK_NAME

Line 292: FROM FA_DEPRN_PERIODS_MRC_V

288: AND PERIOD_COUNTER <= (SELECT MAX(fdp.period_counter)
289: FROM FA_DEPRN_PERIODS_MRC_V fdp
290: WHERE FDP.book_type_code = P_BOOK_NAME
291: AND fdp.fiscal_year < (SELECT MAX(fiscal_year)
292: FROM FA_DEPRN_PERIODS_MRC_V
293: WHERE book_type_code = P_BOOK_NAME
294: AND period_close_date IS NOT NULL));
295:
296: ELSE

Line 411: FROM FA_DEPRN_PERIODS_MRC_V

407: IF upper(P_MRCSOBTYPE) = 'R'
408: THEN
409: SELECT PERIOD_COUNTER
410: INTO p_lex_begin_period_counter
411: FROM FA_DEPRN_PERIODS_MRC_V
412: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
413: AND PERIOD_NAME = P_BEGIN_PERIOD;
414: fnd_file.put_line(fnd_file.log,'R-p_lex_begin_period_counter::'||p_lex_begin_period_counter);
415:

Line 418: FROM FA_DEPRN_PERIODS_MRC_V

414: fnd_file.put_line(fnd_file.log,'R-p_lex_begin_period_counter::'||p_lex_begin_period_counter);
415:
416: SELECT PERIOD_COUNTER
417: INTO p_lex_end_period_counter
418: FROM FA_DEPRN_PERIODS_MRC_V
419: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
420: AND PERIOD_NAME = P_END_PERIOD;
421: fnd_file.put_line(fnd_file.log,'R-p_lex_end_period_counter::'||p_lex_end_period_counter);
422:

Line 460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';

456: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
457: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
458: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
459: LP_FA_RETIREMENTS := 'FA_RETIREMENTS_MRC_V';
460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
461: LP_FA_ASSET_INVOICES := 'FA_ASSET_INVOICES_MRC_V';
462: ELSE
463: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
464: lp_fa_books := 'FA_BOOKS';