APPS.CSP_PACKLIST_HEADERS_PVT dependencies on DUAL

Line 974: FROM DUAL;

970: -- cursors to check if wildcard values '%' and '_' have been passed
971: -- as item values
972: CURSOR c_chk_str1(p_rec_item VARCHAR2) IS
973: SELECT INSTR(p_rec_item, '%', 1, 1)
974: FROM DUAL;
975: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
976: SELECT INSTR(p_rec_item, '_', 1, 1)
977: FROM DUAL;
978:

Line 977: FROM DUAL;

973: SELECT INSTR(p_rec_item, '%', 1, 1)
974: FROM DUAL;
975: CURSOR c_chk_str2(p_rec_item VARCHAR2) IS
976: SELECT INSTR(p_rec_item, '_', 1, 1)
977: FROM DUAL;
978:
979: -- return values from cursors
980: str_csr1 NUMBER;
981: str_csr2 NUMBER;