DBA Data[Home] [Help]

APPS.IEX_REPOSSESSION_PVT dependencies on DUAL

Line 986: FROM DUAL;

982: -- cursors to check if wildcard values '%' and '_' have been passed
983: -- as item values
984: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
985: SELECT INSTR(p_rec_item, '%', 1, 1)
986: FROM DUAL;
987: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
988: SELECT INSTR(p_rec_item, '_', 1, 1)
989: FROM DUAL;
990:

Line 989: FROM DUAL;

985: SELECT INSTR(p_rec_item, '%', 1, 1)
986: FROM DUAL;
987: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
988: SELECT INSTR(p_rec_item, '_', 1, 1)
989: FROM DUAL;
990:
991: -- return values from cursors
992: str_csr1 NUMBER;
993: str_csr2 NUMBER;