APPS.JL_ZZ_GLOBE_VAL_PKG dependencies on FA_MASS_REVALUATIONS

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 535: fa_mass_revaluations mr

531: INTO dummy
532: FROM dual
533: WHERE EXISTS (SELECT 1
534: FROM fa_mass_revaluation_rules rr,
535: fa_mass_revaluations mr
536: WHERE rr.asset_id = p_asset_id
537: AND rr.mass_reval_id = mr.mass_reval_id
538: AND mr.status = 'COMPLETED');
539: RETURN TRUE;