[Home] [Help]
530: SELECT 1
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');