DBA Data[Home] [Help]

APPS.IEX_LITIGATION_PVT dependencies on DUAL

Line 938: FROM DUAL;

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

Line 941: FROM DUAL;

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