DBA Data[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on DUAL

Line 1599: FROM dual;

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

Line 6103: FROM dual;

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