1595: WHERE activity_metric_id = l_act_metric_id;
1596:
1597: CURSOR c_act_met_id IS
1598: SELECT ams_act_metrics_all_s.NEXTVAL
1599: FROM dual;
1600:
1601: -- 05/07/2001 huili for checking the "VARIABLE"
1602: --CURSOR c_dep_info (l_metric_id NUMBER) IS
1603: -- SELECT accrual_type, compute_using_function
6099: WHERE activity_metric_id = l_act_metric_id;
6100:
6101: CURSOR c_get_new_history_id IS
6102: SELECT ams_act_metric_hst_s.NEXTVAL
6103: FROM dual;
6104:
6105: CURSOR c_check_history_id(l_test_id NUMBER) IS
6106: SELECT COUNT(*)
6107: FROM ams_act_metric_hst