APPS.CSD_REPAIR_JOB_XREF_PVT dependencies on DUAL

Line 966: FROM DUAL;

962: -- cursors to check if wildcard values '%' and '_' have been passed
963: -- as item values
964: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
965: SELECT INSTR(p_rec_item, '%', 1, 1)
966: FROM DUAL;
967: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
968: SELECT INSTR(p_rec_item, '_', 1, 1)
969: FROM DUAL;
970:

Line 969: FROM DUAL;

965: SELECT INSTR(p_rec_item, '%', 1, 1)
966: FROM DUAL;
967: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
968: SELECT INSTR(p_rec_item, '_', 1, 1)
969: FROM DUAL;
970:
971: -- return values from cursors
972: str_csr1 NUMBER;
973: str_csr2 NUMBER;