DBA Data[Home] [Help]

APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on FA_DEPRN_PERIODS

Line 251: FROM fa_deprn_periods c,fa_mass_revaluations a

247: END IF;
248:
249: SELECT count(*)
250: INTO dummy
251: FROM fa_deprn_periods c,fa_mass_revaluations a
252: WHERE a.book_type_code = p_book_type_code
253: AND a.status = 'COMPLETED'
254: AND a.mass_reval_id = l_mass_reval_id
255: AND c.book_type_code = a.book_type_code

Line 307: FROM fa_deprn_periods c

303: ,'TAX' ,b.book_type_code)
304: AND b.allow_cip_assets_flag = 'YES'
305: AND b.rowid <> a.rowid
306: AND NOT EXISTS ( SELECT 1
307: FROM fa_deprn_periods c
308: , fa_deprn_periods d
309: WHERE c.book_type_code =
310: a.book_type_code
311: AND c.period_name = p_period_name

Line 308: , fa_deprn_periods d

304: AND b.allow_cip_assets_flag = 'YES'
305: AND b.rowid <> a.rowid
306: AND NOT EXISTS ( SELECT 1
307: FROM fa_deprn_periods c
308: , fa_deprn_periods d
309: WHERE c.book_type_code =
310: a.book_type_code
311: AND c.period_name = p_period_name
312: AND d.book_type_code =