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 6095: FROM dual;

6091: WHERE activity_metric_id = l_act_metric_id;
6092:
6093: CURSOR c_get_new_history_id IS
6094: SELECT ams_act_metric_hst_s.NEXTVAL
6095: FROM dual;
6096:
6097: CURSOR c_check_history_id(l_test_id NUMBER) IS
6098: SELECT COUNT(*)
6099: FROM ams_act_metric_hst