APPS.CSD_REPAIR_HISTORY_PVT dependencies on DUAL

Line 1189: FROM DUAL;

1185: -- cursors to check if wildcard values '%' and '_' have been passed
1186: -- as item values
1187: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
1188: SELECT INSTR(p_rec_item, '%', 1, 1)
1189: FROM DUAL;
1190: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
1191: SELECT INSTR(p_rec_item, '_', 1, 1)
1192: FROM DUAL;
1193:

Line 1192: FROM DUAL;

1188: SELECT INSTR(p_rec_item, '%', 1, 1)
1189: FROM DUAL;
1190: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
1191: SELECT INSTR(p_rec_item, '_', 1, 1)
1192: FROM DUAL;
1193:
1194: -- return values from cursors
1195: str_csr1 NUMBER;
1196: str_csr2 NUMBER;