DBA Data[Home] [Help]

APPS.FA_MC_UPG3_PKG dependencies on FA_DEPRN_PERIODS

Line 307: fa_deprn_periods dp

303: /* CURSOR unposted_periods IS
304: SELECT count(*)
305: FROM
306: fa_book_controls bc,
307: fa_deprn_periods dp
308: WHERE
309: bc.book_type_code = p_book_type_code AND
310: dp.book_type_code = p_book_type_code AND
311: dp.period_counter between

Line 338: FROM fa_deprn_periods dp

334: WHERE bc.book_type_code = p_book_type_code;
335: --added for bug# 5190890
336: SELECT count(*)
337: INTO l_count
338: FROM fa_deprn_periods dp
339: WHERE dp.book_type_code = p_book_type_code
340: and nvl(gl_transfer_flag,'N')<>'Y'
341: and period_close_date is not null
342: and deprn_run is not null;

Line 1106: fa_deprn_periods dp

1102: FROM
1103: gl_je_lines gs,
1104: gl_je_headers gh,
1105: gl_je_batches gb,
1106: fa_deprn_periods dp
1107: WHERE
1108: dp.period_counter = l_pc AND
1109: dp.book_type_code = p_book_type_code AND
1110: dp.reval_batch_id = gb.je_batch_id AND