DBA Data[Home] [Help]

APPS.IEX_LITIGATION_PVT dependencies on DUAL

Line 940: FROM DUAL;

936: -- cursors to check if wildcard values '%' and '_' have been passed
937: -- as item values
938: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
939: SELECT INSTR(p_rec_item, '%', 1, 1)
940: FROM DUAL;
941: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
942: SELECT INSTR(p_rec_item, '_', 1, 1)
943: FROM DUAL;
944:

Line 943: FROM DUAL;

939: SELECT INSTR(p_rec_item, '%', 1, 1)
940: FROM DUAL;
941: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
942: SELECT INSTR(p_rec_item, '_', 1, 1)
943: FROM DUAL;
944:
945: -- return values from cursors
946: str_csr1 NUMBER;
947: str_csr2 NUMBER;