DBA Data[Home] [Help]

APPS.IEX_REPOSSESSION_PVT dependencies on DUAL

Line 984: FROM DUAL;

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

Line 987: FROM DUAL;

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