[Home] [Help]
655: where object_type = p_object_type
656: and object_id = p_object_id;
657:
658:
659: delete pa_perf_kpa_trans
660: where perf_txn_id in (select perf_txn_id from pa_perf_transactions
661: where project_id = p_object_id)
662: and kpa_summary_det_id in (select kpa_summary_det_id from pa_perf_kpa_summary_det
663: where object_type = p_object_type