APPS.CSM_QUERY_PKG dependencies on DUAL

Line 119: FROM DUAL;

115: AS
116: CURSOR c_get_query_id --get query_id
117: IS
118: SELECT CSM_QUERY_B_S.NEXTVAL
119: FROM DUAL;
120:
121: l_query_id NUMBER;
122: l_variable_count NUMBER;
123: l_return_status VARCHAR2(4000);

Line 1218: FROM DUAL;

1214:
1215: CURSOR c_get_next_instance
1216: IS
1217: SELECT CSM_QUERY_INSTANCES_ACC_S.NEXTVAL
1218: FROM DUAL;
1219:
1220: CURSOR c_get_next_qvariableid
1221: IS
1222: SELECT CSM_QUERY_VARIABLE_VAL_ACC_S.NEXTVAL

Line 1223: FROM DUAL;

1219:
1220: CURSOR c_get_next_qvariableid
1221: IS
1222: SELECT CSM_QUERY_VARIABLE_VAL_ACC_S.NEXTVAL
1223: FROM DUAL;
1224:
1225: l_variable_id_lst CSM_INTEGER_LIST;
1226: l_var_value_char_lst CSM_VARCHAR_LIST;
1227: l_var_value_date_lst CSM_DATE_LIST;