APPS.CSP_PICK_SERIAL_LOTS_PVT dependencies on DUAL

Line 833: FROM DUAL;

829: -- cursors to check if wildcard values '%' and '_' have been passed
830: -- as item values
831: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
832: SELECT INSTR(p_rec_item, '%', 1, 1)
833: FROM DUAL;
834: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
835: SELECT INSTR(p_rec_item, '_', 1, 1)
836: FROM DUAL;
837:

Line 836: FROM DUAL;

832: SELECT INSTR(p_rec_item, '%', 1, 1)
833: FROM DUAL;
834: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
835: SELECT INSTR(p_rec_item, '_', 1, 1)
836: FROM DUAL;
837:
838: -- return values from cursors
839: str_csr1 NUMBER;
840: str_csr2 NUMBER;